calculating progressive tax
 

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

Answer: calculating progressive tax
 

Calculating Progressive Tax in Excel

To calculate progressive tax in Excel, use the following formula:

1. Replace A1 with the cell where you input the income amount.
2. The formula checks if the income is less than or equal to 200, in which case the tax is 0.
3. If the income is between 201 and 500, the formula calculates the tax as (income-200)*10%.
4. If the income is between 501 and 1000, the formula calculates the tax as (income-500)*15%+30.
5. If the income is above 1000, the formula calculates the tax as (income-1000)*20%+130.
6. Adjust the income brackets and tax rates as needed for your specific situation.

calculating progressive tax
 

Try

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

Mike

"lebasse" wrote:

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

calculating progressive tax
 

Hi

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

--
Regards
Roger Govier

"lebasse" wrote in message
...
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

calculating progressive tax
 

check out this all purpose solution from John McGimpsey

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

"lebasse" wrote:

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