Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |