Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. Pay overtime only for overtime hours. In cell G5, calculate the gross pay based on the regular and overtime pay. Abrams regular pay is $398. With 8 overtime hours, Abrams overtime pay is $119.40.
Solved by E. D. in 25 mins