Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 20th 08, 10:08 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2008
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  
Old August 20th 08, 11:23 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
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

  #3   Report Post  
Old August 20th 08, 11:27 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
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


  #4   Report Post  
Old August 20th 08, 01:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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 08:55 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017