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

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?

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

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

"klg" wrote in message
...
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?

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

Do forgive me. Your crystal ball must be in the shop right next to mine huh?

http://www.savefile.com/projects/808594667


"Tyro" wrote:

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

"klg" wrote in message
...
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?