Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: calculating progressive tax

Calculating Progressive Tax in Excel

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

Formula:
=IF(A1<=200,0,IF(A1<=500,(A1-200)*0.1,IF(A1<=1000,(A1-500)*0.15+30,(A1-1000)*0.2+130))) 
  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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,081
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
progressive sum balu Excel Discussion (Misc queries) 3 November 18th 07 07:12 PM
Progressive Calculation nospaminlich Excel Worksheet Functions 5 November 1st 05 10:03 AM
progressive select Mike Excel Worksheet Functions 1 June 8th 05 02:08 AM
Progressive summing Maarten Excel Worksheet Functions 5 April 27th 05 10:25 AM
Progressive Dating of Columns Shadyhosta New Users to Excel 4 December 29th 04 06:06 AM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"