Tom

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

Tom

"Tom Ogilvy" wrote in message
...
Type it in or scan it in.

--
Regards,
Tom Ogilvy

"KeyWest JetSki" wrote in message
...
Tom

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

Tom

"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"KeyWest JetSki" wrote in message
...
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