I'm trying to create a payroll processing sheet incorporating IRS tax tables.

I need my sheet to solve the following equation:

IF and employee is S-0 (single & zero dependents), and his wages are greater than $0 but less than $195, then subtract $51 and multiply 10%
greater than $195 but less than $645, then subtract $99 and multiply 15%
greater than $645 but less than $1482.00, then subtract $317 and multiply 25%
greater than $1482.00 but less than $3131.00, then subtract $442.18 and multiply 33%
greater than $3131.00 but less than $6763.00, then subtract $849.58 and multiply 33%
greater than $6763.00 then subtract $1187.49 and multiply 35%

Variables are obviously the gross amount of money earned (< or > than above ranges). The other variable is if an employee is married, single, and how many dependents (S-0 vs. M-4, etc.). Wage ranges will vary according to marriage status & dependents claimed.

Essentially, I would have 12 ranges of earnings that require if < or > and up to 9 sents of changes in ranges (according to dependents).

Any help would be greatly appreciated.
Regards,
V.

Any help would be greatly appreciated