LOOKUP functions?

[MIKDU]

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.

 

[Peo Sjoblom]

One way

http://www.contextures.com/xlFunctions03.html

look at INDEX and MATCH

 

[Ron_D]

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/results.aspx?Scope=TC&Query=Payroll

Good Luck,
Ron

 

[MIKDU]

Thank You very Much. Very Helpful

One way

http://www.contextures.com/xlFunctions03.html

look at INDEX and MATCH

 

[MIKDU]

Thank You, Much. Very Helpful!!!

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/results.aspx?Scope=TC&Query=Payroll

Good Luck,
Ron