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

In network economics, the value of a commercial software vendor's software products:

Natali [406]

Answer:

increases as more people use them.

Explanation:

Network economics refers to a business that uses network effect. It is also called Netromix. The value of a good is increased as the number of buyers increases.

The business will benefit from feedback received by customers that use their products.

For example online services like LinkedIn and Twitter benefit from this type of framework. The more users that use these software th more the business gains.

7 0

3 years ago

You want to go to Europe 5 years from now, and you can save $7,300 per year, beginning one year from today. You plan to deposit

tino4ka555 [31]

Answer:

$36,602.5

Explanation:

Your profit each year of saving $7,300 at 8.5% return each year is $620.5

In that case you earn $7,920.5 each. Multiply by 5 years which is the fifth year you made the last deposit, and you will arrive at $36,602.5

6 0

3 years ago

Read 2 more answers

During the recession of 2008 through 2010, Ford

mars1129 [50]

Answer:

During the recession of 2008 through 2010, Ford saw sales of its vehicles drop and was forced to reduce production. This decision reflected changes in the company's ECONOMIC environment.

Explanation:

The automotive industry crises occurred from 2008 to 2010, it was basically a part of the financial crisis that started in 2007. It also effected most of the Europe, but the results in America were far worst than any other part of the world. The main reason behind it was the rise in the fuel prices for these vehicles. As Ford didn't offer much fuel efficient models for costumers, their sales started to decline, which resulted in the reduction of production, and changed the companies economic environment.

3 0

3 years ago

Tru or false? the older traditional form of management structure is the horizontal organization

Tamiku [17]

The answer is false.

7 0

3 years ago

You operate a car detailing business with a fixed amount of machinery (capital), but you have recently altered the number of wo

NemiM [27]

Answer:

1.5 cars

Explanation:

Three employees can produce a total of:

= 4 × 3

= 12 cars in an hour.

Five employees can produce a total of:

= 3 × 5

= 15 cars in an hour

So, the increase in total product of labor as I increase the labor from 3 to 5 employees:

= Total product when 5 employees are hired - Total products when 3 employees are hired

= 15 - 12

= 3 cars.

So, the marginal product of moving from 3 to 5 workers:

= 3 ÷ 2

= 1.5 cars

3 0

3 years ago