Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of double taxe rates!
Dear All,
Does anyone know how to calculate the tax on a salary? There are two rates of Tax applicable on the salary if it is more than 12,500 up tp 100,000 it is 10% and on above 100,000 it is 20% applicable. eg. if salary of someone is 130,00. the tax should be a followed: (100,000-12,500)*10%=8,750 30,000*20% = 6,000 the total tax is then 14,750. so, my question is how to put this and calculate this in one cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation of double taxe rates!
http://www.mcgimpsey.com/excel/variablerate.html
Or: =MAX(0,MAX(A1-100000,0)*20%+(MIN(100000,A1)-12500)*10%) -- Kind regards, Niek Otten Microsoft MVP - Excel "Nooruddin Oraal" <Nooruddin wrote in message ... | Dear All, | Does anyone know how to calculate the tax on a salary? | There are two rates of Tax applicable on the salary if it is more than | 12,500 up tp 100,000 it is 10% and on above 100,000 it is 20% applicable. | eg. | if salary of someone is 130,00. the tax should be a followed: | (100,000-12,500)*10%=8,750 | 30,000*20% = 6,000 | the total tax is then 14,750. | so, my question is how to put this and calculate this in one cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add excel horizontal & vertical ruler | Excel Worksheet Functions | |||
Excel CSV file: How to preserve double quotation mark on Unix ftp? | Excel Discussion (Misc queries) | |||
Double clicking in a Pivot Table, Please HELP | Excel Discussion (Misc queries) | |||
Calculating p-value from Fisher's Exact Test | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) |