JM wrote:
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.

I thought about that before -- the fact that what you see as $1.60
might not be exactly $1.60. But that should not adversely affect
ROUND() in this case. For example, round($1.6012/0.05,0)*0.05 is
$1.60. Since you used ROUNDUP() previously, I wonder if you misread
the formula and it is still using ROUNDUP() instead of ROUND(). In
that case, yes, $1.6012 would round up to $1.65, whereas $1.60 exactly
would not.