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

Charlotte is trying to measure her salon's productivity during the first quarter. For this period, she should divide ________ by

IRISSAK [1]

Answer:

the total salon services and products sold

Explanation:

Productivity can be regarded as ratio of output volume to that of the volume of inputs. It give the measurements of

production inputs efficiency, these input could be labour, capital. Productivity helps to know how these inputs are been used in production of given level of output in economy.

7 0

3 years ago

A monopoly firm's use of a tariff provides it with additional protection because the tariff:

notsponge [240]

A monopoly firm's use of a tariff provides it with additional protection because the tariff reduces competition from imports by raising the import price.

Option C

<u>Explanation:</u>

A monopoly business is a price-maker, even through the amount, it generate it can control the market rate. When selling less and it can sell far less and can sell more and sell just because the price drops. when making less because it can sell more.

This is due to the fact that the tariff basically transfers the profits out of the international monopolist to the national government.

The monopolist's revenues are limited to an amount provided by the Horizontal stripe when the tax is introduced. Therefore, the tariff increases the total domestic social security as it reduces the profits of the foreign company.

8 0

3 years ago

Find the EAR in each of the following cases (Use 365 days a year. Do not round intermediate calculations and enter your answers

postnew [5]

Answer and Explanation:

The computation of the effective annual rate in each of the following cases are

Effective annual rate = [(1+annual percentage rate ÷ period)^period]- 1

= (1 +0 .09 ÷ 4)^4 - 1

= 9.31%

Effective annual rate = [(1+annual percentage rate ÷ period)^period]- 1

= (1 + 0.16 ÷ 12)^12-1

= 17.23%

Effective annual rate = [(1+annual percentage rate ÷ period)^period]- 1

= (1 + 0.12 ÷ 365)^365-1

= 12.75%

4 .

Effective annual rate = [(e)^Annual percentage rate]-1

e=2.71828

So,

=[(2.71828)^0.11]-1

= 11.63%

4 0

3 years ago

The _____ frame of an organization focuses on providing harmony between the needs of the organization and the needs of people.

earnstyle [38]

Answer:

The correct answer is: human resources.

Explanation:

The Human Resources (<em>HR</em>) department is in charge of recruiting and selecting new personnel with the characteristics and profile the organization is looking for. Besides, the HR role is to provide employees the sources necessary so they can perform their duties in a proper environment within the firm.

3 0

4 years ago

Alumplus Aluminum Company has come up with a new type of metal. However, producing it would take up 75 percent of its manufactur

otez555 [7]

Answer:

D. outsourcing

Explanation:

Outsourcing -

It is the method in a business to hire people from any other company in order to perform a particular task , is known as outsourcing .

The practice of outsourcing have the objective , in order to increase the efficiency of the company or to accomplish any goal with in a very short period of time .

Hence , from the question ,

The Aluminium company Alumplus , outsource people from out side its company to produce the products .

8 0

3 years ago