Tax Calculator

New CT Tax Calculator.xlsx

To anyone who wants to help,

I have attached Australia,s plan to alter the income tax come this Fin year 2012/13. This also has the figures currently for tax. I have tried to make a calculator where anyone can enter the amount they make and it will show how much they made before this new scheme and how much they will make after. Can someone please help? I can work out my figures, but whe I enter random numbers it fails. I am stumped!

Ken

Before

=SUMPRODUCT(--(I1>{6000,37000,80000,180000}),I1-{6000,37000,80000,180000},{0.15,0.15,0.07,0.08})

After

=SUMPRODUCT(--(I1>{18200,37000,80000,180000}),I1-{18200,37000,80000,180000},{0.19,0.135,0.045,0.08})

WOW Bob. That is so simplified on what I was trying to do.

Thanks for the quick reply and now I try to make it all simple again.

Cheers,

Ken