You're right, of course, it would necessarily have 2 different results. For
some reason it just took me awhile to realize it. Please see my answer to
Joe.

And thanks
--
OneFineDay


"Sheeloo" wrote:


If you apply
=-MAX(0,MIN(I9,100)*0.05)
to 90 you will get -4.5, right?
so if have 90 in two cells you will get -9 as total...

if you apply it to 180 (sum of 90 and 90) you will get -5

Hope this helps...

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"M Thompson" wrote:

Hello and thanks for responding so quick. The explanation was very helpful,
and the formula does what I thought. Please see my response to T. Valko's
question. I hope it sheds better light on my problem.
--
OneFineDay


"Sheeloo" wrote:

Not sure what the problem is... this might help
=-MAX(0,MIN(I9,100)*0.05)
The above will give you 0 if I9<0, minus of 5% of I9 if it is between 0 and
100 and -5 if it is above 100
=-MAX(0,(I9-100)*0.02)
The above will give you 0 if I9<100, minus of 2% of I9-100 if it is above 100

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"M Thompson" wrote:

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