Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to build a table into my spreadsheet
12.50 15.00 18.75 21.25 25.00 35.00 40.00 55.00 40.00 55.00 60.00 75.00 50.00 70.00 90.00 100.00 65.00 85.00 100.00 120.00 I typed the above into my spreadsheet but I cannot create a table. How do I create this table or do I need a table at all? I have a spreadsheet that I would like to calculate pay for my employees. The get a special rate depending on how many times they do function. Also I have different level for employees skill levels. Example Level I Jobs Pay 1 $15 2 $35 3 $55 4 $70 5 $85 Level IV Jobs Pay 1 $21.25 2 $55 3 $75 4 $100 5 $120 I keep track of the numbers per shift Exampe Employee Start End Jobs Pay John 0900 1500 5 Joe 0900 1200 2 John is a level 4 Joe is leve 2 I need the formula to calculate the pay column Any ideas? Thanks Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions | |||
VBA Code for a pivot table to open database and to reference table current page | Excel Programming | |||
create a source table from a special pasted value dynamic crossed table | Excel Programming |