Help please,
It has been a while sense I have done work with excel and I am working on a excel sheet to calculate total cost for the day. I am having trouble with calculating the pay because I cannot the best way to do the pay because it is based on Job Class. When he puts in a code the the number of hours worked he would like it to calculate the pay based on the pay chart. Like said it has been several years and I am at a loss. Sample workbook is attached.
It has been a while sense I have done work with excel and I am working on a excel sheet to calculate total cost for the day. I am having trouble with calculating the pay because I cannot the best way to do the pay because it is based on Job Class. When he puts in a code the the number of hours worked he would like it to calculate the pay based on the pay chart. Like said it has been several years and I am at a loss. Sample workbook is attached.