K
klg
I have put the fed tax tables into a spreadsheet and I need to reference them
for a payroll sheet. I need the sheet to be able to calculate the amount of
tax withheld based in the gross. The timesheet is on its own page and the
tables are on their own pages. (i.e. single monthly, married monthly, single
semi-monthly, married semi-monthly, etc.) are seperated on individual sheets.
I tried VLOOKUP, IF, nothing worked - although I'm not sure I did it right.
The gross amount is in H40 on the 'payroll' sheet and one of the tax tables
is on the 'SingMon' sheet. The At Least is A3-138. But Less Than is B 3-138
and columns c-m 3-138 are the withholding amounts.
Can someone help me accomplish this please?
for a payroll sheet. I need the sheet to be able to calculate the amount of
tax withheld based in the gross. The timesheet is on its own page and the
tables are on their own pages. (i.e. single monthly, married monthly, single
semi-monthly, married semi-monthly, etc.) are seperated on individual sheets.
I tried VLOOKUP, IF, nothing worked - although I'm not sure I did it right.
The gross amount is in H40 on the 'payroll' sheet and one of the tax tables
is on the 'SingMon' sheet. The At Least is A3-138. But Less Than is B 3-138
and columns c-m 3-138 are the withholding amounts.
Can someone help me accomplish this please?