Error when using IF functino

[Taylrl]

Hi,

I am trying to create an excel spreadsheet that will show me the amount of UK Income tax I need to pay when I enter my earnings. I'm sure this must be something that someone else has already achieved.

This is the formula that I have at the moment and that is currently not working:

=IF(B16>150001,((B16-150001)*0.45)+((150000-32012)*0.4)+((32011-9441)*0.2)),IF(150000>B16>32012,((B16-32012)*0.4)+((32011-9441)*0.2)),IF(32011>B16>9441,(((B16-9441)*0.2),"Null"))

It currently gives me a "Parse Error". The tax brackets are as follows; <9440 @ 0%, 9441-32000 @ 20%, 32001-150000 @ 40%, 150001+ @ 50%. Can anyone see where I am going wrong or have another idea of how I could do this?

Thanks a lot in advance!!

Regards,
Taylrl

[Jonmo1]

Try

=IF(B16>150001,((B16-150001)*0.45)+((150000-32012)*0.4)+((32011-9441)*0.2),IF(B16>32012,((B16-32012)*0.4)+((32011-9441)*0.2),IF(B16>9441,((B16-9441)*0.2),"Null")))

[martindwilson]

IF(32011>B16>9441 is wrong it should be if(and(32011>B16,B16>9441), same for IF(150000>B16>32012

[alansidman]

Replace this part of the statement: IF(150000>B16>32012
with: If(And(150000>B16,B16>32012)

Replace this part of the statement: IF(32011>B16>9441
with If(And(32011>B16, B16>9441)

[Tony Valko]

Maybe this...

=B16*LOOKUP(B16,{0;9441;32001;150001},{0;0.2;0.4;0.5})