All categories

3 years ago

Which formula is correct formatting for a nested function?

Business

1 answer:

erastova [34]3 years ago

7 0

Answer:

=IF(AND(B2>3000,02>2000),"Bonus","No Bonus")

Explanation:

A nested If statement is used when 1 or more conditions are to be tested. The result of the nested function depends based on the true value of the function.

i.e. If the nested statement is true, certain operations are to be done otherwise, do something else. In other words, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.

The syntax of a nested function goes thus

IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))

This would be equivalent to the following in Excel

= IF(condition1,"value_if_true",value_if_false)

Base on the above explanation, only option B is right.

And what it does is that

it checks if cell B2 is greater than 3000 AND cell 02 is greater than 2000.

If both statement are true, "Bonus" will be the output result

If one ore both statement are false, "No Bonus" will be the output result

You might be interested in

Which of the following statements is correct?a. Monopolistic competition is similar to monopoly because both market structures a

nata0808 [166]

Answer:

The correct answer is (A)

Explanation:

Monopoly and monopolistic competition are similar in many ways. In both type of markets the firms are usually the price makers. Being the only firm in the market gives them an opportunity to earn abnormal profits and in both cases firms earn abnormal profits. Perfect competition is a type of market that is totally different in terms of number of sellers and buyers. In perfect competition firms are the price takers.

4 0

3 years ago

Suppose that in the U.S. consumer market, the demand for credit cards is increasing. As the demand for credit cards increases, w

Anna [14]

Answer:

Both equilibrium quantity and interest rate will shift to the right.

Explanation:

A shift to the right on those two factors candidates a general increase in the market.

As a demand for a certain product increase, The producer will match it up by increasing the supply of that product in order to accommodate as many consumers as possible. This will cause the equilibrium between demand and supply increased.

As the consumers base grow, there will be more competitors show up to offer the credits for the customers. This will make the potential income that credit providers decreased. As a response, it is very common for them to raise the interest rates for the credit.

8 0

3 years ago

Without health insurance, a routine checkup at the doctors office can cost you?

defon

Answer:

between $300 and $600

Explanation:

8 0

3 years ago

When using straight line amortization on premium bonds:_______.

Vsevolod [243]

Answer: the same interest income is reported each year

Explanation:

The straight-line amortization method is a simple way to amortize a bond as an equal amount of interest are allocated over every accounting period.

When using straight line amortization on premium bonds, the same interest income is reported each year. Therefore, option A is the best answer.

5 0

3 years ago

The two viking spacecraft did not find convincing evidence of life on mars, nor did the phoenix lander. do these results imply t

belka [17]

They don't. Water was found and there are actually implications that if it doesn't exist nowadays, it might have historically existed long before there was even life on earth. There are theories that there was life on Mars millions of years ago way before earth had life.

5 0

3 years ago