Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
salary tax calculation f
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% In this case for example if the salary is 1200 then it is subject to three taxes i.e 10% upto the icome of 500 , 15% for (501-1000) aand 20% for the remaining 200 dollar . Apprciate your help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
salary tax calculation f
Try
=MIN($A$1-200,300)*10%+MIN($A$1-500,500)*15%+MAX(0,A1-1000)*20% With your salary In A1 20% tax!!! can I come and live by you? 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% In this case for example if the salary is 1200 then it is subject to three taxes i.e 10% upto the icome of 500 , 15% for (501-1000) aand 20% for the remaining 200 dollar . Apprciate your help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
salary tax calculation f
John McGimpsey has a clever way to do this for brackets of varying sizes:
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% In this case for example if the salary is 1200 then it is subject to three taxes i.e 10% upto the icome of 500 , 15% for (501-1000) aand 20% for the remaining 200 dollar . Apprciate your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Salary | Excel Discussion (Misc queries) | |||
time shift and salary calculation | Excel Discussion (Misc queries) | |||
Salary programme | Excel Discussion (Misc queries) | |||
How can I do an hourly salary calculation in Excel | Excel Discussion (Misc queries) | |||
Function for decreasing salary by 2.5% | Excel Worksheet Functions |