Remember Me?

#1
August 20th 08, 10:08 AM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2008 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
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 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
 external usenet poster First recorded activity by ExcelBanter: Jul 2007 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
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

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

All times are GMT +1. The time now is 01:10 AM.