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
Factor completely, then place the answer in the proper location on the grid. 6x ^2 - 3x - 30
seraphim [82]
Factor out the GCF first
3(2x² - x - 10)
3(2x - 5)(x + 2)
3 0
4 years ago
Read 2 more answers
Write the number below as a fraction in its simplest form<br> 0.569
san4es73 [151]

Answer:

\binom{569}{1000}

Step-by-step explanation:

Step 1:

\binom{0.569}{1}

Step 2:

Then multiply both by 1000

\binom{569}{1000}

It cant be simplifyed further so its in simplest form

8 0
3 years ago
Given the geometric sequence where a1 = 2 and the common ratio is 4, what is the domain for n?
Karo-lina-s [1.5K]
The general term is a_n (a sub n; n is a subscript)

The first term is a1
The second term is a2
The third term is a3
and so on...

The first term starts at n = 1. We replace the n in a_n with 1 to get a_1. A similar thing happens with n = 2 and onward

The domain is therefore the set {1, 2, 3, 4, 5, ...} which is the set of...
* Counting numbers
* Positive Whole numbers
* Natural numbers
Those are three ways to express the same set

We can also say n \ge 1 where n is an integer or whole number
A similar inequality would be n \ \textgreater \ 0 which is effectively the same as idea as the last inequality (n is also an integer or whole number).
4 0
4 years ago
4. Calculate the product of 8/15, 6/5, and 1/3.
RSB [31]
A because the 6 and 3 cancel out
Then 2 x 8 is (16) and 15 x 5 is (75)
Making it A
6 0
3 years ago
Read 2 more answers
Find the domain and range of the INVERSE of the given function.<br> Square root x-3
Ulleksa [173]
f(x)=\sqrt{x-3}\\&#10;y=\sqrt{x-3}\\&#10;y^2=x-3\\&#10;x=y^2+3\\&#10;f^{-1}(x)=x^2+3\\&#10;D:x\in\matxbb{R}\\&#10;R:y\in\langle3,\infty)
4 0
4 years ago
Other questions:
  • Which is the graph of the linear inequality y &lt; 3x + 1?
    5·2 answers
  • How many millimeters are equivalent to 2.7 liters
    14·1 answer
  • A rectangular plot of land is to be seeded with grass. If the plot is 22 meters by 22 meters and a 1 kilogram bag of seed is nee
    8·1 answer
  • What would be the opposite definition of a circle ?? Helpp
    12·1 answer
  • What is the volume of the cone? Cone V = 1/3 Bh V = 1/3 πr2h V = 1/3 π32(8) V = 1 3 π(9)(8) V = 1/3 π(72) The cone has a volume
    7·2 answers
  • Plz help out I’ll give brainliest :)
    12·1 answer
  • Helpppppppppppppppppppppppppp and thx u
    13·2 answers
  • I really need help on this. You don’t have to but if you can help it’s greatly appreciated and I will mark you brainliest!!
    14·2 answers
  • The drama club can wash 9 cars in 40 minutes.  At this rate, how many cars can they wash in 2 hours? Caution: turn hours to minu
    10·1 answer
  • Someone answer and explain ILL MARK BRAINLIEST
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!