You didn't mention what happens if A1 = 96.

You also didn't mention what to do if A1 = 136.

AND ... your formula *doesn't add* 10% to the difference, it just takes 10%
*of* the difference.

Care to clear up the differences?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mbys14932" wrote
in message ...

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