salary tax calculation f

[lebasse]

How can i calculate progressive tax. For example if all income up to 200$ is
exempted from any tax and :
$ 201-500 taxed 10%
501-1000 taxed 15%
1001 and above 20%

In this case for example if the salary is 1200 then it is subject to three
taxes i.e 10% upto the icome of 500 , 15% for (501-1000) aand 20% for the
remaining 200 dollar .

Apprciate your help

 

[Mike H]

Try

=MIN($A$1-200,300)*10%+MIN($A$1-500,500)*15%+MAX(0,A1-1000)*20%

With your salary In A1

20% tax!!! can I come and live by you?

Mike

 

[Duke Carey]

John McGimpsey has a clever way to do this for brackets of varying sizes:

http://www.mcgimpsey.com/excel/variablerate.html