View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Conditional Rounding

Hi Annie

For some strange reason you are shifting the general rounding rule by
0.0001. Normally 5 would round up but you want it to round down. So you
have to adjust your number.

E.g. if you number is in A1. The formula in B1 is =Round(A1-0.0001,3)
That way you shift it and then round to 3.