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.
|