CARTMONKEY
New Member
- Joined
- Oct 8, 2002
- Messages
- 1
Here's the situation. I have a tax table. I need to calculate the taxes that a person must pay, given their taxable income.
Here's basically how it is setup:
The IF is the main function. The argument of the IF function is whether the person is single or married(I know how to do that).
The second variable to the IF function is three VLOOKUPS for the single person table, and the third variable for the if function is the three VLOOKUPS for the married person table.
All together there are six vlookups and one if function. I hope this helps and I'm sorry if it sounds confusing!
I just need the first 3, for the single person, and I can figure out the rest.
The mathmatical formula is:
Taxable Income - Threshold Taxable Income(This is Vlookup #1) * Marginal Rate(this is #2) + Basic Amount(this is #3).
Taxable income is given in a single cell. The Threshold Taxable Incomes, Marginal Rates, and Basic Amounts are all in a table, and VLookup seeks out the correct location for them.
Here is the psuedocode for the part I need:
IF(tax status="single", (Taxable Income - VLOOKUP(Threshold Taxable Income) * VLOOKUP(Marginal Rate) + VLOOKUP(Basic Amount)).
I have figured out everything upto calculating the Taxable Income-Threshold income, and that code is:
IF(C16="Single", D16-VLOOKUP (D16,$B$8:$D$13,1).
I cannot for the life of me figure out the rest of this code(for the final 2 parts).
Here is the Excel Table setup:
C16=Single
D16=$43,245. This is the Taxable Income.
COLUMN 1 of the Table is Threshold Taxable Income.
COLUMN 2 is Basic Amount.
COLUMN 3 is Marginal Rate.
$B$8:$D$13 is the Vlookup table area.
Just for reference, a line on EXCEL looks like:
Threshold Taxable Income B19=$24,000
Basic Amount C19=$3,900
Marginal Rate D19=15.0%
Taxable Income D16=$43,245
Math would be (D16-B19)*(D19)+C19.
The Vlookup needed is above.
HELP!
Here's basically how it is setup:
The IF is the main function. The argument of the IF function is whether the person is single or married(I know how to do that).
The second variable to the IF function is three VLOOKUPS for the single person table, and the third variable for the if function is the three VLOOKUPS for the married person table.
All together there are six vlookups and one if function. I hope this helps and I'm sorry if it sounds confusing!
I just need the first 3, for the single person, and I can figure out the rest.
The mathmatical formula is:
Taxable Income - Threshold Taxable Income(This is Vlookup #1) * Marginal Rate(this is #2) + Basic Amount(this is #3).
Taxable income is given in a single cell. The Threshold Taxable Incomes, Marginal Rates, and Basic Amounts are all in a table, and VLookup seeks out the correct location for them.
Here is the psuedocode for the part I need:
IF(tax status="single", (Taxable Income - VLOOKUP(Threshold Taxable Income) * VLOOKUP(Marginal Rate) + VLOOKUP(Basic Amount)).
I have figured out everything upto calculating the Taxable Income-Threshold income, and that code is:
IF(C16="Single", D16-VLOOKUP (D16,$B$8:$D$13,1).
I cannot for the life of me figure out the rest of this code(for the final 2 parts).
Here is the Excel Table setup:
C16=Single
D16=$43,245. This is the Taxable Income.
COLUMN 1 of the Table is Threshold Taxable Income.
COLUMN 2 is Basic Amount.
COLUMN 3 is Marginal Rate.
$B$8:$D$13 is the Vlookup table area.
Just for reference, a line on EXCEL looks like:
Threshold Taxable Income B19=$24,000
Basic Amount C19=$3,900
Marginal Rate D19=15.0%
Taxable Income D16=$43,245
Math would be (D16-B19)*(D19)+C19.
The Vlookup needed is above.
HELP!