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. Abram’s regular pay is $398. With 8 overtime hours, Abram’s overtime pay is $119.40.

Question

contestada

Respuesta :

MrRoyal MrRoyal · Answer 1 · 2022-02-24T22:29:03+01:00

Excel formulas are expressions used to perform computation.

The Excel formula to enter in cell E5 is =IF(D5<$B$21,D5,$B$21) * C5
The Excel formula to enter in cell E5 is =IF(D5>$B$21,(D5-$B$21) * C5 * $B$22, 0)

From the complete question, cell B21 represents base work hour

So, we start by checking if the work hour in cell D5 is less than the base work hour in cell B21

If yes, the work hour remains D5; otherwise the work hour is cell B21

The work hour is then multiplied by the rate in cell C5

Hence, the Excel formula to enter in cell E5 is =IF(D5<$B$21,D5,$B$21) *

Here, we start by checking if the work hour in cell D5 is greater than the base work hour in cell B21

If yes, the overtime hour the difference between D5 and B21; otherwise the overtime hour and pay is 0

The over time hour if there is, is then multiplied by the rates in cells C5 and B22

Hence, the Excel formula to enter in cell E5 is =IF(D5>$B$21,(D5-$B$21) * C5 * $B$22, 0)