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