Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculating percentages | Excel Discussion (Misc queries) | |||
Calculating Percentages | Excel Discussion (Misc queries) | |||
Calculating percentages | Excel Programming | |||
calculating percentages | Excel Discussion (Misc queries) | |||
Calculating percentages | Excel Worksheet Functions |