Hi TerryJr
Couple of ways. Assuming the cell x value is in A1.
1: LOOKUP:
=A1*LOOKUP(A1,{0,18201,37001,80001},{0,0.19,0.325, 0.37})
2: VLOOKUP:
If you place a small table somewhere in the sheet. Say D1:E4
.......0 0.0%
18201 19.0%
37001 32.5%
80001 37.0%
=A1*VLOOKUP(A1,D1:E4,2,1)
http://www.contextures.com/xlFunctions02.html
Quote:
Originally Posted by TerryJR
I've spent hours looking for the answer to this and can't find it. I'm working on a home budget spreadsheet and it includes a tax table that I can update.
I've got a couple of the tax brackets working but I can't figure out the middle one.
$18,201 - $37,000 = 19c for each $1 over $18,200
$37,001 - $80,000 = 32.5c for each $1 over $37,000
$80,001 - $180,000 = 37c for each $1 over $80,000
What if then statement do I use to say, If "cell x" is greater than 37001, but less than 80000, then multiply "the unknown number inbetween" by 32.5%.
Perhaps I'm using the wrong formula? Suggestions anyone? I appreciate the help.
|