Calculation of double taxe rates!

[Nooruddin Oraal]

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?

 

[Niek Otten]

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


| 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?