View Single Post
  #1   Report Post  
TerryJR TerryJR is offline
Junior Member
 
Posts: 2
Smile 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.