| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a daily rate when the rate could be fixed or variable | New Users to Excel | |||
| multiple rate formulas........ | Excel Discussion (Misc queries) | |||
| Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
| Calculate correct interest on loan when debtor pays late | Excel Discussion (Misc queries) | |||
| $20,000 due. Pays diff $ every x. Int calc per annum. Need excel . | Excel Worksheet Functions | |||
Hybrid Mode
