Formula Help

[KeyWest JetSki]

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

 

[Tom Ogilvy]

Any formula would requiring knowing how all the data is laid out and where
the table is that defines the level for each employee.

In any event, you would use functions like Offset, index, vlookup, lookup
and related.

 

[KeyWest JetSki]

Tom

the table is on paper not in the spreadsheet how would I add that to the
spreadsheet?

Tom

 

[Tom Ogilvy]

Type it in or scan it in.

 

[KeyWest JetSki]

Tom

My question was how to create a table in the spreadsheet
I already type the table into rows and columns

Tom

 

[Tom Ogilvy]

That is a table. You don't need to create it. If you would like to make it
a named range, select the data and do

Insert=>Name=>Define

Name: Table1
Refersto: -- will already have the address of the selection

Click the Add button.

Now in a formula (as an example)

=vlookup(A1,Table1,2,False)

where A1 contains John or whatever identifies the employee and is in the
leftmost column of the table.

This would return the employees type if it were in column 2 of the
table/data.

You could replace Table1 in the formula above with the raw address if you
didn't want to name the range.