Calculation of double taxe rates!

G

Guest

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top