Calculate to the third decimal and round up or down in cell
As far as I know, the ROUND function does what you want. ie rounds down if
below 5, round up if 5 or above.
ROUNDUP rounds up, regardless and ROUNDDOWN rounds down regardless.
Try putting 1.2225 into A1, the =ROUND(A1,3) into A2.
It should round up to 1.223
Change A1 to 1.2224
It should round down to 1.222
Regards - Dave.
|