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
If the height of the rectangle is 12 ft and the area is 72 ft what is the base of the rectangle
xxMikexx [17]
6 ft is the base of the rectangle
5 0
3 years ago
Read 2 more answers
Please help and show work!!
serious [3.7K]

17.

x = -2 is not a solution of -1 < x < 5 because -2 < -1 (-1 < -2 < 5 FALSE).

18.

m = 5 is a solution of 5 ≤ m because 5 ≤ 5 ( 5 ≤ m → m ≥ 5 greater than 5 or equal 5, 5 is equal 5)

19.

k = 10 is not solution of 2k - 3 < 1 because:

put the value of k to the inequality:

2(10) - 3 < 1

20 - 3 < 1

17 < 1 FALSE

5 0
3 years ago
I need help ASAP you must drag each of those tiles and match them up to the photos
iren2701 [21]

Answer:

Step-by-step explanation:

how we supposed to do it , when we cant control it

3 0
3 years ago
Identify all solutions for a triangle with A = 38 degrees b = 10, and a= 8. Round to the nearest tenth.
rjkz [21]

Answer:

A = 38°

B = 50.32°

C = 91.68°

a = 8

b = 10

c = 12.77

Step-by-step explanation:

The first thing is to find the angle B, like this:

sin B = b * sin A / a = 10 * sin (38 °) / 8

sin B = 0.77

B = arc sin (0.77)

B = 50.32 °

For angle C, it would be:

C = 180 - 38 - 50.32

C = 91.68 °

Side c, we calculate it like this:

c = a * sin C / sin A = 8 * sin (91.68 °) / sin (38 °)

c = 12.77

5 0
3 years ago
Ronald is calculating the time required to fill the swimming pool at school. He found that it takes 8 minutes to fill the swimmi
tester [92]

Answer:

<u>The rate the swimming pool is filled is 9 gallons of water per minute</u>

Step-by-step explanation:

Let's review the information provided by Ronald to us to help him to find the answer to the question:

Time it takes to fill the swimming pool = 8 minutes

Amount of water the swimming pool can hold = 72 gallons

2. At what rate does the swimming pool fill, in gallons per minute?

Rate the swimming pool is filled = Amount of water the swimming pool can hold /Time it takes to fill the swimming pool

Replacing with the real values, we have:

Rate the swimming pool is filled = 72/8 = 9 gallons of water per minute

4 0
3 years ago
Other questions:
  • Liz wants to buy her favorite musical group’s new CD. The CD costs $15.24, including tax. Liz gives the store clerk a twenty-dol
    5·2 answers
  • WILL CHOOSE BRAINIEST How many 6-digit numbers, formed using each digit from 1 to 6 exactly once, are divisible by: a.)5 b.)6 c.
    9·2 answers
  • D is the centroid of △ABC. What is the value of x when GD=x+4 and GC=4x+5?
    6·1 answer
  • Over the summer, for every 12 okra seeds Dana planted, 7 grew into plants. If he planted 156 okra seeds, how many grew into plan
    13·1 answer
  • Which expression is equivalent to (x^4/3 x^2/3)^1/3?
    7·2 answers
  • The graph of a logarithmic has a vertical asymptote at x=4 , contains the point (e+4, 1) , and has an x-intercept of 5. Which fu
    8·1 answer
  • We want to construct a box with a square base and we currently only have 10m2 of material to use in construction of the box. Ass
    14·1 answer
  • Find the median of the data. 43, 37, 49, 51, 56, 40, 44, 50, 36
    8·1 answer
  • Where is the body?????????????????????????????????
    9·2 answers
  • 9. To stitch a shirt, 2 m 15 cm cloth is needed. Out of 40 m cloth, how many shirts can be stitched and how much cloth will rema
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!