How to use multiple if statements?

  • Thread starter Thread starter Brett
  • Start date Start date
B

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
 
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
Click to expand...

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!
 
Back
Top