Multiple rate of pays

  • Thread starter Thread starter Denise
  • Start date Start date
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.
 
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
 
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



.
Click to expand...
 
Back
Top