Rounding
I just noticed what is causing the problem...the column I am using for the
price is adding up the cost, markup and tax, thus has rounding issues there.
The $1.60 showing was actually $1.6012. When I hardkey the $1.60 it works.
So I need the price formula to round also.
wrote in message
ups.com...
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).
|