Rounding
JM wrote:
The formula I am using is =ROUND(A1/0.05,0)*0.05 and it works for everything
that is not on the nickel. For those prices on the nickel, the formula is
rounding up to the next nickel. Meaning that $1.60 is rounding to $1.65.
What adjustment do I need to make to the formula?
Works fine for me as-is. I am using Office Excel 2003 (11.5612.5606).
|