Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If/cross referencing functions
Hi,
I have a workbook for working out rates of pay for staff based on scales of pay and hours worked. I'm trying to get the supervisors to complete the hours and excel to go find the scale, lookup the hours and report the relevant pay. At the moment I'm trying to use one sheet for data entry and a 7 column (1 for hours worked and 6 for scales) x 25 row (we pay differing amounts for every 1/4 hour worked!) table for the lookup - and it's not proving easy. Help Darren |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If/cross referencing functions
You need to provide more details.
Biff "Darren_Preston" wrote in message ... Hi, I have a workbook for working out rates of pay for staff based on scales of pay and hours worked. I'm trying to get the supervisors to complete the hours and excel to go find the scale, lookup the hours and report the relevant pay. At the moment I'm trying to use one sheet for data entry and a 7 column (1 for hours worked and 6 for scales) x 25 row (we pay differing amounts for every 1/4 hour worked!) table for the lookup - and it's not proving easy. Help Darren |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Referencing Cells Using If Functions | Excel Worksheet Functions | |||
referencing cols in functions - NPV | Excel Worksheet Functions | |||
Functions referencing unopened workbooks | Excel Worksheet Functions |