Forum Discussion
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...
Hi Jim,
You can use the TRUNC( )function with the required format in the required cell or cells.
Example:
if you are using =SUM(A1:A2) to get the sum of the Cell A1:A2
You can add the TRUNC( ) function with the following format to limit it to 2 numbers after the decimal without roundup the number.
=TRUNC(SUM(A1:A2),2)
IMHO, TRUNC does exactly the same as ROUNDDOWN if use with same number of digits
- Sergei,
You are absolutely right.