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.

 calculating progressive tax
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## calculating progressive tax

#1
August 20th 08, 10:08 AM posted to microsoft.public.excel.misc
 lebasse external usenet poster Posts: 1
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?

lk
#2
August 20th 08, 11:23 AM posted to microsoft.public.excel.misc
 Mike H external usenet poster Posts: 11,501
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?
>
> lk

#3
August 20th 08, 11:27 AM posted to microsoft.public.excel.misc
 Roger Govier[_3_] external usenet poster Posts: 2,480
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?
>
> lk

#4
August 20th 08, 01:17 PM posted to microsoft.public.excel.misc
 Duke Carey external usenet poster Posts: 1,081
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?
>
> lk

 Thread Tools Display Modes Linear Mode

 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 User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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 12:25 AM.