Table Help
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
|