Try this:

Put this table in F1:G13
Income Rate
0 Nil
1501 18
2001 25
3001 30
5001 40
6001 45
7001 50
8001 90
9001 110
15001 130
25001 150
40001 200

Then, this formula returns the rate associated with the value in A2

=VLOOKUP(A2,F2:G13,2,1)

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Montu" wrote in message
...
I have a tax rate slab like
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 like
=if(a2=1500,"Nil",if(a2<2001,18,if(a2<3001,25,if(a 2<5001,30,if(a2<6001,40,if(a2<7001,45,if(a2<8001,5 0,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