Hi All,

Trying to do the IF function on a calculation, not sure if that is what
I should be using, here is the problem.

I am trying to do a calculation on a cell, with three conditions. If
the amount is less than £96 display 0, if the amount is more than £96
(but less than £136) take the difference and add 10%. Upto here is
fine =IF(A1<96,0,IF(A196,(A1-96)*10/100))

The problem is when I try to add another condition to do the last sum.

so if the amount in A1 is greater that £136, add 10% from £96 upto £136
and then 22% on the ress of the amount.

So the formula should be something like this, but it is not working!
=IF(A1<96,0,IF(A196,(A1-96)*10/100)),IF(A1136,(A1-96)*10/100)+(A1-136)*22/100))

Thanks in advance


--
mbys14932
------------------------------------------------------------------------
mbys14932's Profile: http://www.excelforum.com/member.php...o&userid=34914
View this thread: http://www.excelforum.com/showthread...hreadid=546523