Calculate withholding

I have made a simple table to automatically calculate what an employee makes according to the hours he/she worked and the appropriate deductions such as FICA, Medicare and Federal W/H, but I do not know how to go about making the Federal W/H work. I am not sure what the correct method is to do this. I have added the table I am working on.


I can make a chart for their filing status:

employee A single, 0 exemptions
employee B single, 1 exemption
employee C single, 0 + $5
employee D single, 0 + $5

Then there is the tax table from the IRS (Pub 15, page 41). Do I have to list all of this or is there a formula I could use to figure this such as =IF(then use > and < then, col 1,0) or something like that, by the way as you can see I do not have a specific cell reference yet. Or do I use VLOOKUP? and copy the IRS Table? What is the proper way to do this?

Please review what I have done so far and advise me if that is the best way to make those calculations and how I should proceed to do the Federal W/H section. Thanks for your patience with a newbie.