IF for Payroll Processing

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

Hi,

Not sure if the attached is what your after, but it may help. Simply adjust the formula in cell B9 to accomodate the different scales for the other variables (M1...M9).

Kind regards,

Robert