cell A correct formula will yield the result: $518 Overtime Pay: This section's IF function will calculate the overtime pay. If employee has worked more than 40 hours, you will multiply only the hours by the hourly rate and then multiply by the Overtime Rate Hours Work 40)*Hourly Rate Overtime Rate. If the employee did not earn overtime, should return a zero