What will be the result of this formula =if(a1<100000,a1*5%,a1*7.5%) , if the cell a1 has a value of 90000?

What will be the result of this formula =if(a1<100000,a15%,a17.5%) , if the cell a1 has a value of 90000?

Answers

Answer 1

For this IF function, look at cell A1. The logical test asks if the value in A1 is less than 100,000: in this case, the value of 90,000 would be less. If the value in A1 is under 100,000, the value is to be multiplied by 0.05 (5%), and multiplied by 0.075 if it is 100,000 or greater (7.5%). For a value of 90,000 * 0.05, the value that would be displayed in the cell with the IF function would be 4,500.

Related Questions

A car is tracing at a rate of 72 kilometers per hour. What is the car rates in kilometers per min? How many kilometers will the car travel in 5 mins

Answers

1 hour= 60 minutes

72km/60 minutes= 1.2 km per minute

1.2(5)= 6 km

The car’s unit rate is 1.2 kilometers per minute and the car travel 6 kilometers in 5 minutes.

Hope this helps!

In 5 minutes, the car will travel 6 kilometers.

To convert the car's speed from kilometers per hour to kilometers per minute, we need to divide the given rate by the number of minutes in an hour, which is 60. So, for a car traveling at 72 kilometers per hour, the rate in kilometers per minute is:

72 km/hr / 60 = 1.2 kilometers per minute.

Now, to calculate how many kilometers the car will travel in 5 minutes, we simply multiply the rate in kilometers per minute by the number of minutes:

1.2 km/min * 5 min = 6 kilometers.

Therefore, the car will travel 6 kilometers in 5 minutes at the rate of 72 kilometers per hour.

Colin took out a loan with a principal of $32,800. After five years, the interest and principal totaled $48,872. If Colin made monthly payments of $816 for five years until the loan was paid off, how much did Colin pay in service charges? a. $16,072 b. $88 c. $16,160 d. $163

Answers

816 * 5 * 12= 48960

If the P and I totaled 48872, then...
48960 - 48872= 88

The service charges were $88 B.

The service charges would be, $88

What is mean by Subtraction?

Subtraction in mathematics means that is taking something away from a group or number of objects. When you subtract, what is left in the group becomes less.

Given that;

Colin took out a loan with a principal of $32,800.

And, After five years, the interest and principal totaled $48,872.

Now,

The value of principal amount is,

⇒ 816 × 5 × 12 = 48960

Now, We get;

Amount of Colin pay in service charges is,

48960 - 48872= 88

Hence, The service charges were $88

Learn more about the subtraction visit:

https://brainly.com/question/17301989

#SPJ5

what is the answer to 2(6b + 8) = 4 + 6b

Answers

2(6b + 8)=4 +6b
or, 12b+16=4+6b
or,12b-6b=4-16
or,6b= -12
or,b= -12/6
or, b= -2

Step 1. Distribute the 2 into the parenthesis ( we do this because the whole parenthesis and the 2 are multiplying)
Step 2. Get “b” by itself. ( to solve for a letter like b, we need to have it on one side of the equal sign)
Step3. Divide by 6 because we are undoing the multiplication of 6timesB. ( what you do on one side you do to the other side) divide the 6 into the -12.
There you go the answer is B= -2

If the probability of Stephan Curry missing a free throw is 6%, what are the odds of him hitting the next free throw?

Answers

Answer:

47 : 3

Step-by-step explanation:

Odds of hitting are the ratio of hits to misses:

94 : 6, or 47 : 3.

Subtract using the number line. −4−(8)

Answers

The answer is -12 because the 4 and 8 are negative

Answer:

-12

Step-by-step explanation: I Took K12 TEST

I need help with #6 plzzzz

Answers

First, find the unit rate.
Since the car travels 476 miles with 14 gallons of gas, then 476/14 = 34, so the car can travel 34 miles per gallon.

The distance is 34 times the number of gallons

d = 34g

Now you are given 578 miles, and you need to find the gallons.

578 = 34g

Solve for g by dividing both sides by 34.

g = 17

He needs 17 gallons.

How to do you simplify
1/5(40x^5+13x^3-3x-5)-(3x^5-5x^3+5x)

Answers

Greetings!

Simplify.
[tex]1/5(40x^5+13x^3-3x-5)-(3x^5-5x^3+5x)[/tex]
Distribute the Parenthesis.
[tex]8x^5+2.6x^3-0.6x-1-3x^5+5x^3-5x[/tex]
Combine Like Terms.
[tex]8x^5-3x^5+2.6x^3+5x^3-0.6x-5x-1[/tex]
The Answer Is:
[tex]5x^5+7.6x^3-5.6x-1[/tex]

Hope this helps.
-Benjamin

Simplify the expression
–5.6 + 8.2
Answers:

–2.6

–13.8

2.6

13.8

Answers

This can be rewritten as 8.2 - 5.6 so it is easier to solve.

8.2 - 5.6 = 2.6

Hope this helps!

–5.6 + 8.2

The answer is 2.6 because with a - and + you subtract the two number and whichever is the highest number that is the sign that you put. In this case, the highest number is a +8.2 so your answer will be POSITIVE.

If the highest number was a negative for example, 5.6+ -8.2 then your answer will be -2.6

®PLEASE MARK AS BRAINLIEST TO HELP ME LEVEL UP®

If 9/10 yard of material is needed to make a blanket, how many blankets can be made from 27 yards of material

Answers

27 / (9/10) =
27 * 10/9 =
270/9 =
30 <=== 30 blankets can be made with 27 yds of material

If a line of one billion people standing shoulder to shoulder stretches 346,439 miles long, what is the average shoulder width, in feet, of the people in the line?

Answers

Final answer:

Given a line of one billion people extending for 346,439 miles, the average shoulder width of a person in the line is approximately 1.83 feet.

Explanation:

To find the average shoulder width of the people in the line, we need to convert the total miles into feet, since the result wanted is in feet. There are 5,280 feet in one mile. So the total length in feet would be 346,439 miles * 5,280 feet/mile = 1,829,029,920 feet. Now, if there are 1 billion people in this line, then the average width of a person's shoulders would be the total length divided by the total number of people. Hence, the average shoulder width = 1,829,029,920 feet / 1,000,000,000 people = approximately 1.83 feet.

Learn more about Average Shoulder Width here:

https://brainly.com/question/5689581

#SPJ11

One-third cup of black beans provides 20% of the potassium you need daily. You must get the remaining 1,360 milligrams from other sources. How many milligrams of potassium should you consume daily?

Answers

5×20%=100% so 1360mg is 80% of the daily requirement. The total requirement is 1360/0.8=13600/8=1700 mg.

80 percent of needed milligrams is 1360

1360/.80 = x/1

1700 milligrams or 1,700 milligrams of potassium

PLEASE ANSWER IVE BEEN WAITING FOR AN HOUR

Rachel earned 34 in 4 hours at her job today she wants to know how much she could earn (e) tommorow if she works 10 hours at the same hourly rate

A. E/34 = 4/10
B. 34/4 = E/10
Solve the proportion to determine how much Rachel will earn in 10 hours.

Answers

So she earned $34 in 4 hours, meaning she was earning at the rate of 34/4 or $8.5/hour. Is she works for 10 hours at the same rate, it would be 8.5 x 10 = $85. B is the correct proportion.

The correct equation of proportions would be $34 x
------- . Set this = to --------
4 hr 10 hr

$34 x
_____ = --------- Cross multiply: ($34)(10 hr) = 4(hr)x
4 hr 10 hr

Cancel "hr" on both sides. Then $340 = 4x, and x = $85.

She could earn $85 working 10 hours.

Of the students at Milton Middle School, 99 are girls. If 45% of the students are girls, how many total students are there at Milton Middle school?

Answers

that is how i found the answer

220-45%=121
220-99=121
220

The Murphys are on vacation and want to go on a helicopter tour. The tour itself costs $125 per person and they also have to pay a fuel fee of $50. If there are four people in the family, how much will the tour cost them?

Answers

4 x 125 + 50
= 500 + 50
= $550

The answer is, indeed, $550.

Dane is 10 times Brian's age. The difference in their age is 27, how old is Brian

Answers

Brian is 3 years old.
Hope this helps!

Answer:

Brain is 3 years old.

Step-by-step explanation:

Let B represent Brain's age and D represent Dane's age.

We have been given that Dane is 10 times Brian's age. We can represent this information in an equation as:

[tex]D=10B...(1)[/tex]

We are also told that the difference in their age is 27. We can represent this information in an equation as:

[tex]D-B=27...(2)[/tex]

Upon substituting equation (1) i equation (2), we will get:

[tex]10B-B=27[/tex]

[tex]9B=27[/tex]

[tex]\frac{9B}{9}=\frac{27}{9}[/tex]

[tex]B=3[/tex]

Therefore, Brain is 3 years old.

how to write 412.638 using fractions

Answers

412 is a whole number, 638 is the number you want to look at.

your answer is 412 638/1000

or 412 63.8/100

hope this helps

That could be 412 and 319/500 .

Help me asap! I will mark you brainly and a heart tysm!

:D

Answers

The answer is A) -4/25 because when you multiply 8/15 and -3/10, you can simplify the expression to 4/5 times -1/5, which equals -4/25.

8 /15 * -3/10 = -24/150 = -4/25

Write a linear equation that models the cost y of one person going on x rides at the fair. Graph the equation. Admission is $12 and rides are a $1 each. Please help

Answers

the equation is y=x+12 where action X represents how much rides were ridden total and 12 is the one-time admission fee

Solve: 2(4x - 6) = 6x - 4

A) 4
B) 8
C) -4
D) no solution

Answers

it's A .positive 4 ¡!!!!!!!!!

Rewrite the following statement using a number in scientific notation.

The diameter of a certain bacterium is about
0.00000002
0.00000002 meters.

Answers

[tex]\bf 0.\stackrel{\textit{8 decimals}}{00000002}\implies 2.0\times 10^{-8}~meters[/tex]

since 2 is the first significant digit, a nonzero, then we move the dot that way, it just so happen it's 8 spots to the right.

Jordan is chopping wood for the winter. For 10 days in a row, he follows the same process: In the morning, he chops 20 pieces of wood, and in the evening, he chops an additional 30 pieces of wood. On the 11 day, Jordan chops only 5 pieces of wood. Write a numerical expression with parentheses for the total number of pieces of wood Jordan chopped. Do not simplify your expression.

Answers

i would write this:

total = 10(20+30) +5

10 x (20 + 30) + 5
10 x 50 + 5
500 + 5

What is the equation for the linear model in the scatter plot obtained by choosing the two points to the closest line?
y=-1.5 X +6
yEquals 1.5 X +6

Answers

(4,12) (20,36)
slope = (36 - 12)/(20-4) = 24 / 16 = 3/2 = 1.5

y intercept (0,6) b = 6
equation
y = 1.5x + 6

answer
b. y = 1.5x + 6

Final answer:

The equation for the linear model in a scatter plot can be determined by selecting any two points closer to the line and utilizing them to find its slope and y-intercept. This information is then used to write the equation y = mx + b, where m is the slope and b is the y-intercept.

Explanation:

The question pertains to the equation of the linear model in a scatter plot which basically describes the best fit line passing through the points on the plot. In simple terms, in a scatter plot if you choose any two points closer to the line, we can use these to determine the equation of that line.

Suppose you have two points (x1, y1) and (x2, y2), where x represents the independent variable and y is the dependent variable. To find the slope (m) of the line, we use the formula: m = (y2 - y1) / (x2 - x1). Once the slope is determined, we proceed to find the y-intercept (b), which is the y-value where the line crosses the y-axis.

The general form of a linear equation is y = mx + b. Hence, using the values of slope and y-intecept obtained earlier, we can write the equation of our line. For example, in the equations given in the question, -1.5 and 1.5 are the slopes and 6 is the y-intercept.

Learn more about Linear Model Equation here:

https://brainly.com/question/35321629

#SPJ2

A company wants to decrease their energy use by 15%. If their electric bill is currently $1300 a month, what will their bill be if they are successful?

Answers

Since 15%=0.15 by moving the decimal 2 places to the right, 15% of 1300 can be found by multiplying 1300 by 0.15, resulting in 195 as 15%. Since we have to subtract 15% from our answer (15% is not our final answer), 1300-195=1105 as our answer

Surface area of a cylinder with a diameter of 14 and height is 9

Answers

The radius is 7 if the diam. is 14. We can find the surface area (without top or bottom areas) by finding the circumference of the base and then multiplying it by the height:

C=pi*d = pi(14); height = 9. Then the surface area of the side(s) is 14(pi)(9).

If you wish to include the areas of the top and bottom of the cylinder, add
2(pi)r^2 = 2(pi)(7)^2.

Grass can grow up to 6 inches in a week depending on temperature humidity and time of year at this rate how tall grass grow in 24 days

Answers

keeping in mind there are 7 days in a week.

[tex]\bf \begin{array}{ccll} inches&days\\ \text{\textemdash\textemdash\textemdash}&\text{\textemdash\textemdash\textemdash}\\ 6&7\\ x&24 \end{array}\implies \cfrac{6}{x}=\cfrac{7}{24}\implies \cfrac{6\cdot 24}{7}=x[/tex]

Jordan has 260 basketball cards. He divides them into 4 equal groups. How many cards are in each group?

Answers

Jordan has 260 basketball cards and divides them evenly into 4 groups, resulting in 65 cards per group.

Jordan has 260 basketball cards and wants to divide them into 4 equal groups. To find the number of cards in each group, we need to perform a simple division. By dividing 260 by 4, we get:

Divide 260 by 4.

260 \/ 4 = 65.

Each group will have 65 cards.

Therefore, Jordan will have 65 basketball cards in each of the four groups.

write the number in expanded form 259,341

Answers

the answer is 200,00 + 50,000 + 9,000 + 300 + 40 + 1 hope that helps!

Using the following production tally, determine how many total mousetraps were produced during a shift:

Quantity per package: 60
Number of packages you sealed: 41
Starting quantity in first package (from previous shift): 52
Ending quantity in your last unsealed package (leave for next shift): 24
Rejected mousetraps: 34

Answers

2466
No. of Packages sealed
= (1 for PreviousShift) + (40 for MyShift) = 41.

PreviousShift top-up: (60-52)
MyShift sealed: (40x60) [for MyShift’s production only]
MyShift unsealed: 24
Rejected: 34

Total = 8 + 2400 +24 + 34
= 2466
i answered this question on yahoo as well

Write the contrapositive of the conditional statement. If a polygon is regular, then it has congruent angles and congruent sides.

Answers

The contra positive of the conditional statement is this: IF A POLYGON DOES NOT HAVE CONGRUENT ANGLES AND CONGRUENT SIDES THEN IT IS NOT A REGULAR POLYGON.
forming a contra positive statement involves switching the hypothesis and the conclusion portions of conditional statement and negating both.

the fully shaded grid shows 1. EXPLAIN how these three models are related

Answers

They're all related because they all equal "one." The first one has 1/100, the second one has 10/100 and the third one has 100/100. They all relate because they all have ones.

Other Questions

Find the perimeter of the figure. 2 1/4 in, 4 1/12in, 3 2/3in What is the square root of 99 simplified? The political roots of the progressive movement lay in the Are the people involved in or affected by project activities and include the project sponsor, project team, support staff, customers, users, suppliers, and even project opponents. A group of people united to promote a cause is called a Historically, __________ was the dominant sector in the very early years of the united states. A gram of gold has the same ____ as a kilogram of gold Catherine has been diagnosed with intellectual disability due to maternal alcohol exposure. she goes to a regular school, instead of attending special classes. this educational philosophy that places catherine in a regular set up in society is an example of What is a music parameter? Name and describe the three categories of parameters.If you could at least explain what a parameter is that would be great. I looked it up but I don't understand the definition. How do you puncuate the sentence the students began to gry because their homework was due? Levio is a company that makes mobile apps and has decided to become a market leader in the field. levio can encourage the development of a culture where workers perceive that new ideas are welcomed by offering challenging work and supervisory encouragement. in other words, the company can create a(n) ____. A diver descends to a location of 5014 meters relative to the surface of the water. He then descends another 1012 meters.What is the divers final location relative to the surface of the water?Enter your answer as a simplified mixed number in the box. The united states is comprised of a culture that accepts a wide array of personal behaviors and attitudes, foods, dress, and other products and services. thus, the united states values _____. When reading science articles, why should you look for the author's biases? What is the area of a rectangle with vertices at (6, 3) , (3, 6) , (1, 2) , and (2, 1) ? Enter your answer in the box. Do not round any side lengths. Which equation can be used to find the value of b if side a measures 8.7 cm? 8.7 + b = 54.6 17.4 + b = 54.6 26.1 + b = 54.6 34.8 + b = 5 In your own words what is the application of columbia cna with 5 sheep blood agar At the market 8 apples cost $4 how much do 9 apples cost ? Describe what happens to chromosomes before mitosis. The Song rulers changed the way Chinese officials were selected. Under their new system, officials needed to pass tests and prove they were able to do the work. What was this system called?Operating system.Merit system.Economic system.Caste system.Yall took to long. for anyone who needs the answer, it is Merit system. Steam Workshop Downloader