1 Start Excel. Download and open the file
0.000 namedexploring _ e02 _ grader _ h2. xlsx. Read the business rules in the range A27: G34.
2 Enter an IF function in cell E5 to calculate the regular
9.000 pay based on a regular 40-hour work week for the first employee. If the employee worked 40 hours or less, calculate the pay based on the hourly rate and number of actual hours worked. If an employee worked more than 40 hours, calculate the pay based on the hourly rate for only 40 hours. Use relative and absolute cell references appropriately. Do not enter the value 40 in the function. Refer to cell B21 that contains the value instead.
3 Enter an IF function in cell F5 to calculate the overtime
9.000 pay for the first employee. If an employee worked less than 40 hours, the overtime pay is 0. If an employee worked 40 or more hours, calculate the overtime pay on only the overtime hours based on 1.5 times the hourly pay rate. Use relative and absolute cell references appropriately. Do not enter the values 40 and 1.5 in the