Hello,

You can nest the IF function so that it fulfils multiple criteria, I assume that if a gross income is say £40,000 then the income tax will be 20%(32000) + 40%(40000 - 32000) which results in 6400 + 3200 = £9600

Going on this basis you can also use a SUMPRODUCT formula and set up some tables before hand to assist with the calculations.

For example to work out the National Insurance based on your values and a 40k gross income:

=SUMPRODUCT((40000/52>{0;155;827})*(40000/52-{0;155;827})*({0;0.12;-0.1}))*52

This returns £3832.80 (National insurance paid per annum) take off the *52 at the end if you want it weekly.

Similar logic can be applied to the income tax part, you can set up an array for the bracket values to make it easier so instead of having {0;155;827} you might want B1:B3 (where B1=0, B2=155, B3=827)

I hope this makes sense. Let me know if you need anything else clearing up.

Also it might be worth taking off the pension from the income before hand as that is free from tax(?)

## Like this thread? Share it with others