Aon
New Member
- Joined
- Feb 12, 2009
- Messages
- 2
I need for the user to be able to input there annual salary, then select there state (from a pull down, that is generated from a list) I need a formula too take that information go through and find the persons state. Then basically scan through that individual states tax brackets & return the tax rate based on the income. I have played with this for a couple of days, I cannot figure out how to structure the formula. I’m assuming I need to use a combination of the “IF” function and the VLOOKUP.
Here are the facts:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
Sheet 1<o
></o
>
<o
></o
>
B6 - User inputs annual income.
<o
></o
>
F2 – User selects state from drop down.
<o
></o
>
G3 – Tax percentage is displayed. (Formula needs to go in this cell)
<o
></o
>
Sheet 2
<o
></o
>
I have all states and there corresponding Tax brackets listed in
Columns - A, B & C Rows – 1:202
<o
></o
>
I have a the states drop down being generated from a list named “states”
As you can see it is in column F1:F53. The reason I didn’t just use column “A” is because I couldn’t get the drop down to ignore the blank cells. If there is a different way to do this, I’m all ears.
Here are the facts:
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com




Sheet 1<o


<o


B6 - User inputs annual income.
<o


F2 – User selects state from drop down.
<o


G3 – Tax percentage is displayed. (Formula needs to go in this cell)
<o


Sheet 2
<o


I have all states and there corresponding Tax brackets listed in
Columns - A, B & C Rows – 1:202
<o


I have a the states drop down being generated from a list named “states”
As you can see it is in column F1:F53. The reason I didn’t just use column “A” is because I couldn’t get the drop down to ignore the blank cells. If there is a different way to do this, I’m all ears.
