Income Tax

Hi Richard,

Thank you for your question and welcome to the forum.

You would need to use a formula similar to this which included the sumproduct function and array formulas

Here is a sample formula:

=SUMPRODUCT(C2>6000,21600,58000,70000}),C2-{6000,21600,58000,70000},{0.17,0.13,0.12,0.05})

C2 being the amount of income and if c2>6000 then income - 6000 is taxed at 0.17.

I hope this helps.

Regards

Simon