IF, At least, Less Than, Then, VLOOKUP?

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?
 
T

Tyro

Without an example of your tax table and your formula, and not being a mind
reader, I have no clue how to answer your question.

Tyro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top