Hi everyone, My question is related to a payroll programming question that I have run into. Basically, I want to be able to compute the Federal tax deductions from each employee every pay period.
On a seperate worksheet, I have two tables set up for both married and single employees. Ultimately what I would like a funtion to do is look at the marital status and number of dependents that an employee has and then find the correct tax percentage on the tax table that corresponds with their gross wages, marital status, and number of dependents. Any suggestions or ideas would be awesome!!
K2=Gross Wages
D1: Marital Status
E1: Number of dependents
On seperate worksheet
B4:I13 = Tax table for married
B19:I27 Tax table for single
Bookmarks