A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

calculating progressive tax



 
 
Thread Tools Display Modes
  #1  
Old August 20th 08, 10:08 AM posted to microsoft.public.excel.misc
lebasse
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
Ads
  #2  
Old August 20th 08, 11:23 AM posted to microsoft.public.excel.misc
Mike H
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

  #3  
Old August 20th 08, 11:27 AM posted to microsoft.public.excel.misc
Roger Govier[_3_]
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


  #4  
Old August 20th 08, 01:17 PM posted to microsoft.public.excel.misc
Duke Carey
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
progressive sum balu Excel Discussion (Misc queries) 3 November 18th 07 06:12 PM
Progressive Calculation nospaminlich Excel Worksheet Functions 5 November 1st 05 09: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 05:06 AM


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


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