How to use multiple if statements?

[Brett]

Does Excel 2002 offer something that will replace using multiple if
statements (if that is possible)?

Say I am calculating state taxes. If income meets a certain range, I
apply a specific tax amount. I need a way to test that the income is
within the range. How can this be done?

Thanks,
Brett

 

[Frank Kabel]

Hi
maybe something like
=IF(AND(A1>1,A1<=100),1,IF(AND(A1>100,A1<=200,2,3))

 

[Don Guillett]

Have a look at HELP index for VLOOKUP. Set up a table and use that function.

 

[Domenic]

Does Excel 2002 offer something that will replace using multiple if
statements (if that is possible)?

Say I am calculating state taxes. If income meets a certain range, I
apply a specific tax amount. I need a way to test that the income is
within the range. How can this be done?

Thanks,
Brett

One way,

Assuming that you enter your table in column A and B, set-up something
like this:

INCOME TAX RATE
$0.00 15%
$10,000 20%
$20,000 25%
$30,000 30%

Then, enter the text "Income:" in a cell, lets say A9
Enter the text "Tax Rate:" in A10
Enter this formula in B10: =IF(B9=0,0,VLOOKUP(B9,A2:B5,2))

It should look something like this:

Income:
Tax Rate: 0.3

Now, whenever you enter an income amount in cell B9, you'll
automatically be given the tax rate for that income bracket.

Hope this helps!