calculating progressive tax

[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%

Or simply speaking income tax calculation in excel. How should the formula
is written?

Apprciate your help
lk

 

[Mike H]

Try

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

Mike

 

[Roger Govier]

Hi

Try
=MAX(0,A1-200)*10%+MAX(0,A1-500)*5%+MAX(0,A1-1000)*5%

 

[Duke Carey]

check out this all purpose solution from John McGimpsey

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