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