1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
user100 [1]
2 years ago
8

Use IF functions to calculate the regular pay and overtime pay based on a regular 40-hour workweek in cells E5 and F5. Pay overt

ime 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.
Mathematics
1 answer:
g100num [7]2 years ago
3 0

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

You might be interested in
You have the option of buying 20 tickets at the fair for 15$ or 45 for 27$ which is te best deal
Lostsunrise [7]
45 tickets for 27$is definitely the best deal because if you go with the first option and buy it twice you will pay 25$for only 40 I can’t Explain properly but definitely 45 for 26$
3 0
3 years ago
Read 2 more answers
Help please!!!<br> What is P(0.6 ≤ z ≤ 2.12)?<br> 16% <br> 26% <br> 73% <br> 98%
Lelu [443]
26% is the answer to your question
5 0
3 years ago
Read 2 more answers
Consider this expression: 4(5x - 7y). Enter an expression that shows the difference of exactly two terms that is equivalent to 4
Eddi Din [679]

Answer:

First you do what is inside the parentheses. 10 x 5 - 3. 50 - 3 =47. Then you multiply 47 x 5 = 235.

Step-by-step explanation:

8 0
3 years ago
Read 2 more answers
At a little known vacation spot taxi fares are a bargain. A 49 mile taxi ride takes 56 minutes and cost $39.20. You want to find
artcher [175]
And 49 mile costs $39.20
So 1 mile costs $0.80
$0.8 x 34 = $27.20
8 0
2 years ago
What is the slope of<br> the line?<br><br> Give your answer as<br> a fraction in simplest<br> form.
Tema [17]

Answer:

3/4

Step-by-step explanation:

The answer is 3/4, because we rise 3 and run 4 the formula is always rise over run, and thats why its 3/4

Hoped this helped!!

6 0
2 years ago
Other questions:
  • Which of the following are point-slope equations of the line going through (-5, 6) and (1, 1)? A. y + 6 = -6/5 (x - 5)
    11·1 answer
  • The sum of two numbers is 121. If the larger number is thirteen more than the smaller number, find both numbers
    14·1 answer
  • Laura estimated the total cost of attending a private four-year university using the information in the table. Category Estimate
    13·2 answers
  • Help solve plz thanks
    5·2 answers
  • Show all steps<br> 16/x+10=8/2x-1
    12·1 answer
  • If 8x -16 = 0 what is the value of x
    15·2 answers
  • Amber got a raise. her hourly wage increased from $8 to $10 an hour. How much did amber's hourly wage increase. Show your work.
    9·2 answers
  • Find the point of intersection by graphing each of the following lines: x+y=4<br> x+2y=6
    8·1 answer
  • Determine the total surface area of each right triangle-based prism
    11·1 answer
  • Find the perimeter of the rectangle
    15·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!