Home |
Search |
Today's Posts |
#1
|
|||
|
|||
LOOKUP functions?
I'm working on a payroll sheet that will automatically list the correct
Federal Income Tax assessed based on the employee's Marital status-Single or Married, the claimed dependents, and the gross income. I have three sheets. The first sheet shows the marital status and the gross income. The other two sheets (one for married and the other for single) gives a chart where the possible depents claimed are in columns and there is a range of incomes like More than 500 in column A row 6, but less than 510 in column B row 6. The cell intersection of claimed dependents with the row of appropriate limits is the money value that needs to go in the Federal Tax Column for the employee. How can I correlate the data to do that automatically. Thank You. |
#2
|
|||
|
|||
One way
http://www.contextures.com/xlFunctions03.html look at INDEX and MATCH -- Regards, Peo Sjoblom "MIKDU" wrote in message ... I'm working on a payroll sheet that will automatically list the correct Federal Income Tax assessed based on the employee's Marital status-Single or Married, the claimed dependents, and the gross income. I have three sheets. The first sheet shows the marital status and the gross income. The other two sheets (one for married and the other for single) gives a chart where the possible depents claimed are in columns and there is a range of incomes like More than 500 in column A row 6, but less than 510 in column B row 6. The cell intersection of claimed dependents with the row of appropriate limits is the money value that needs to go in the Federal Tax Column for the employee. How can I correlate the data to do that automatically. Thank You. |
#3
|
|||
|
|||
MIKDU,
A good starting point is already available. There's a template called Payroll Calculator that you can download from Office Online. Here's the link: http://office.microsoft.com/en-us/re...&Query=Payroll Good Luck, Ron "MIKDU" wrote: I'm working on a payroll sheet that will automatically list the correct Federal Income Tax assessed based on the employee's Marital status-Single or Married, the claimed dependents, and the gross income. I have three sheets. The first sheet shows the marital status and the gross income. The other two sheets (one for married and the other for single) gives a chart where the possible depents claimed are in columns and there is a range of incomes like More than 500 in column A row 6, but less than 510 in column B row 6. The cell intersection of claimed dependents with the row of appropriate limits is the money value that needs to go in the Federal Tax Column for the employee. How can I correlate the data to do that automatically. Thank You. |
#4
|
|||
|
|||
Thank You very Much. Very Helpful
"Peo Sjoblom" wrote: One way http://www.contextures.com/xlFunctions03.html look at INDEX and MATCH -- Regards, Peo Sjoblom "MIKDU" wrote in message ... I'm working on a payroll sheet that will automatically list the correct Federal Income Tax assessed based on the employee's Marital status-Single or Married, the claimed dependents, and the gross income. I have three sheets. The first sheet shows the marital status and the gross income. The other two sheets (one for married and the other for single) gives a chart where the possible depents claimed are in columns and there is a range of incomes like More than 500 in column A row 6, but less than 510 in column B row 6. The cell intersection of claimed dependents with the row of appropriate limits is the money value that needs to go in the Federal Tax Column for the employee. How can I correlate the data to do that automatically. Thank You. |
#5
|
|||
|
|||
Thank You, Much. Very Helpful!!!
"Ron_D" wrote: MIKDU, A good starting point is already available. There's a template called Payroll Calculator that you can download from Office Online. Here's the link: http://office.microsoft.com/en-us/re...&Query=Payroll Good Luck, Ron "MIKDU" wrote: I'm working on a payroll sheet that will automatically list the correct Federal Income Tax assessed based on the employee's Marital status-Single or Married, the claimed dependents, and the gross income. I have three sheets. The first sheet shows the marital status and the gross income. The other two sheets (one for married and the other for single) gives a chart where the possible depents claimed are in columns and there is a range of incomes like More than 500 in column A row 6, but less than 510 in column B row 6. The cell intersection of claimed dependents with the row of appropriate limits is the money value that needs to go in the Federal Tax Column for the employee. How can I correlate the data to do that automatically. Thank You. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow refence in the "table_array" position of Lookup functions | Excel Worksheet Functions | |||
Lookup Functions | Excel Worksheet Functions | |||
lookup using only the functions | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
Lookup Functions | Excel Worksheet Functions |