Prev: if formula results in False - can you help?
Next: How to format the phone number
From: Denise on 5 Mar 2010 17:24
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.
From: Russell Dawson on 5 Mar 2010 17:30
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.
From: Pete_UK on 5 Mar 2010 17:36
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 <Den...(a)discussions.microsoft.com> 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.

From: Denise on 8 Mar 2010 14:22
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 <Den...(a)discussions.microsoft.com> 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.
>
> .
>
From: Denise on 8 Mar 2010 14:31
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 <Den...(a)discussions.microsoft.com> 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.
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: if formula results in False - can you help?
Next: How to format the phone number