I'm hoping someone somewhere can tell me what's happening and how to fix it.
This is the formula I'm using:
=-MAX(0,MIN(I9,100)*0.05)+-MAX(0,(I9-100)*0.02) and copy down through I11

Starting in I9 I have the following amounts.
I Results i'm getting
570.75 (14.42)
246.36 (7.93)
38.18 (1.91)

If I do a Total cell and use the same calculation on it, the answer will be
20.10, which is what I expect. The results of 9-11 are obviously going to
total to more than 20.10. Can someone explain what's happening and is there
a way to fix it so that the results are reasonably in line. It seems to me
to be too big a difference to be a rounding thing??

Thanks
--
OneFineDay