Forum Discussion
Jim Higbee
Oct 15, 2017Copper Contributor
Limiting number of decimal places in a returned formula
I have an Ex 2010 formula that returns 4 decimal places (.7501). I need to use only the first 2 decimal places (.75) for another calculation. I have tried roundup, and although the cell only display...
SergeiBaklan
Oct 20, 2017Diamond Contributor
IMHO, TRUNC does exactly the same as ROUNDDOWN if use with same number of digits
Oct 20, 2017
Sergei,
You are absolutely right.
You are absolutely right.