# I am trying to find a formula to calculate tax for the co-workers, to figure out how

Fantastic news! We've Found the answer you've been seeking!

## Question:

**I** am trying to find a formula to calculate **tax** for the co-workers, to figure out how much they bank annually. There are different tax rates depending on annual salary.

There is a **Fixed Tax plus a tax percentage of everything above the bottom bracket, but not over the next bracket.**

see the example of the table below.

The sheet is massive, so I need a formula, probably a LOOKUP-formula, to drag down and to have excel figure out how much tax they are paying.

They pay tax on salary + bonus + commission. I am not allowed to make a new column with PRE-tax income.

Tax Table | |||||||

Yearly income brackets | Fixed Tax | Tax Percentage | |||||

From zero to $18.000 | $ - | $ - | 0% | ||||

$ 18 000 | $ - | 19% | No fixed tax, just percentage | ||||

$ 35 000 | $ 3 000 | 30% | $3000 FIXED tax, PLUS 30% on every $1 above | ||||

$ 85 000 | $ 18 000 | 35% | etc... | ||||

$ 180 000 and above | $ 50 000 | 45% | |||||

JOB | ANNUAL SALARY | BONUS | COMISSION | INCOME TAX | |||

Cellphone repair | $ 52 870,00 | $ 4 627,35 | |||||

Accountant | $ 52 871,00 | $ 4 627,35 | $ 4 322,00 | ||||

Manager | $ 87 230,00 | $ 17 203,00 | $ 7 323,00 | ||||

Marketing | $ 98 654,00 | $ 8 965,00 | $ 2 078,00 | ||||

HR Consultant | $ 52 874,00 | $ 2 459,00 | $ 700,00 |

**Related Book For**

## Entrepreneurship & Small Business Management

ISBN: 978-0133767186

2nd edition

Authors: Steve Mariotti, Caroline Glackin