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)
<h3 /><h3>The regular pay</h3>
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) *
<h3>The overtime pay</h3>
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)
Read more about Excel formulas at:
brainly.com/question/1285762
