Use IF functions to calculate the regular pay and overtime pay based

$20$

on a regular $40-$hour workmeek in cells E$5$ and F$5.$ Pay overtime only for overtime hours. In cell $G,$ calculate the gross pay based on the regular and overtime pay. Abram's regular pay is $$398.$ With $8$ overtime hours, Abram's overtime pay is $$119\mathrm{.}40.$

Hint: #$1$: To calculate the Regular Pay in cell E$5,$ wite an IF function that checks to see if the hours worked is less than or equal to the base work hours $(40)$ in cell B$21.$ If your logical statement results in true, retum the hours worked. If it results in false, retum the base work hours in cell B$21.$ Multiply the result of your IF function by the hourly wage. Use relative and absolute references accordingly so your functions can be filled down.

#$2$: To calculate the overtime pay, wite an IF function to see if the hours worked is greater than the base work hours in cell B$21.$ If true, within the true argument subtract the base work hours from the hours worked and then multiply the result by the hourly wage and then by the overtime rate in cell B$22.$ If false, retum a $0.$ Again, make sure to use appropriate relative or absolute references.

#$3$: To calculate the gross pay, add the regular pay and overtime pay together.