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: Formula:
|
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 |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com