Multiple rate of pays

D

Denise

On a spreadsheet, the date worked would be in column A; employees' name are
in column B. An individual maybe listed several times in column B . In
column C would be # of hours worked that day. What formula could be used so
I don't have to type the rate of pay (which should stay hidden) for each
person every day?
Thanks.
 
P

Pete_UK

You would normally set up a table somewhere (on a second hidden sheet
perhaps) which will have the person's name and the rate of pay,
something like this:

John 5.50
Fred 10.00
Mary 12.00
Anne 7.50
etc.

Suppose this is in columns A and B of Sheet2. Then in D2 of Sheet1 you
could have:

=VLOOKUP(B2,Sheet2!A:B,2,0)*C2

to give you the cost for that employee (i.e. rate times hours worked).
Then copy the formula down as far as needed.

Hope this helps.

Pete
 
D

Denise

Worked great...THANKS!

Pete_UK said:
You would normally set up a table somewhere (on a second hidden sheet
perhaps) which will have the person's name and the rate of pay,
something like this:

John 5.50
Fred 10.00
Mary 12.00
Anne 7.50
etc.

Suppose this is in columns A and B of Sheet2. Then in D2 of Sheet1 you
could have:

=VLOOKUP(B2,Sheet2!A:B,2,0)*C2

to give you the cost for that employee (i.e. rate times hours worked).
Then copy the formula down as far as needed.

Hope this helps.

Pete



.
 
D

David Biddulph

You can find the syntax of the VLOOKUP function by typing VLOOKUP into Excel
help.
 

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