Thanks for your suggession, but I don't want to use vlookuup formula, because
this formula only find the exact value i.e. 1500 or 2000 or 3000 etc. but I
want to calculate in between value i.e. 1501 to 2000 or 2001 to 3000 etc. So
I thaught that if function can solve this problem. So what should I do ?
Please help me.

"arno" wrote:

Hi,

I'd guess that you need an extra column where you calculate the tax for each
row if you have to split the income according to rows. otherwise make a
better table and use vlookup on it. make sure you set true/false right! (You
will need "TRUE" this is why it is important to have a perfect table.)

See Excel help on vlookup.

arno