Multiple rate of pays
 

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.

Multiple rate of pays
 

How you approach this depends upon factors that you have not mentioned i.e.
How many employees and how many rates of pay and what determines the rate of
pay.
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Denise" wrote:

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.

Multiple rate of pays
 

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

On Mar 5, 10:24*pm, Denise wrote:
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.

Multiple rate of pays
 

Worked great...THANKS!

"Pete_UK" wrote:

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

On Mar 5, 10:24 pm, Denise wrote:
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.

.

Multiple rate of pays
 

One thing, what does the...,2,0) towards the end of the formula mean?

"Pete_UK" wrote:

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

On Mar 5, 10:24 pm, Denise wrote:
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.

.

Multiple rate of pays
 

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


"Denise" wrote in message
...
One thing, what does the...,2,0) towards the end of the formula mean?

"Pete_UK" wrote:

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

On Mar 5, 10:24 pm, Denise wrote:
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.

.