Help with calculating tax percentages
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.
|