M

#### Montu

Sl. Income Rate

1 1500 or Less Nil

2 1501 to 2000 18

3 2001 to 3000 25

4 3001 to 5000 30

5 5001 to 6000 40

7 6001 to 7000 45

8 7001 to 8000 50

9 8001 to 9000 90

10 9001 to 15000 110

11 15001 to 25000 130

12 25001 to 40000 150

13 40001 to above 200

Now I want to put a formula to calculate the tax of a person. So I have

write a formula lik

=if(a2=1500,"Nil",if(a2<2001,18,if(a2<3001,25,if(a2<5001,30,if(a2<6001,40,if(a2<7001,45,if(a2<8001,50,if(a2<9001,90,if(a2<15001,110,if(a2<25001,130,if(a2<40001,150,200))))))))))))

but problem is that ms excel 2003 not allowed input more than 7 times if

condition at a time in a cell.

So how could I calculate tax as above of a person,

Thanks in advance