How to use if analysis

[Ashley78]

I am actually working as Finance Manager and we use excel spreadsheet t
compute monthly salaries. Recently the tax rates have changed and
would like to be guided on devising appropriate formulae.


There are different tax rates as follows:

Chargeable Income
(Rs) Rate(%)
1,923 10
1,924-3,846 20
3,847-38,462 25

38,462 30

I would like to be guided on devising appropriate formulae so that th
computation of tax is automatic. For eg if if someone has a chargeabl
income of Rs83,000, how would the formulaes be inserted in an exce
woorksheet so that we finally get tax to be paid of Rs22,240

 

[Norman Harker]

Hi Ashley78!

See:

http://www.mcgimpsey.com/excel/variablerate.html

 

[Arvi Laanemets]

Hi

=CHOOSE(MATCH(E3;{0;1,923;3,846;3,462;99999};1);10;20;25;30)