Formula computing problem
Are you saying that the total of:
-14.42 + -7.93 + -1.91
Should be -20.10
If so, you'll have to explain why you think that should be the result.
The formulas are returning the correct results. Maybe they're not doing what
you think they're doing.
--
Biff
Microsoft Excel MVP
"M Thompson" wrote in message
...
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
|