View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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.