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

The primary purpose of protective covenants is to help:

velikii [3]

<span>The primary purpose of protective covenants is to help: Lender protection
when a lender loan some amount of money to a debtor, the lender has to face a risk that the debtor wouldn't be able to pay back the money.
Through protective covenants, the lender could get some sort of protection against that risk.</span>

7 0

3 years ago

If the government tightens up on drug dealers and raises the costs of dealing illegal drugs, then the drug addicts' dollar expen

pentagon [3]

Answer:

Explanation:

I'm sure the question was geared toward teaching you the difference between elastic and inelastic.

If your demand for a product does not change even if the price goes up, then the demand is considered to be inelastic.

However, the question posed to get this teaching point across made the answer almost impossible. A drug addict's demand can drastically change from day to day depending on how readily that person can get hold of the money needed. One day money may not be a problem so the expenditure will increase because their demand is price-inelastic. The very next day the person may not be able to find any money at all. Therefore, the expenditure will decrease because their demand is price-elastic

4 0

2 years ago

A government budget deficit affects the supply of loanable funds, rather than the demand for loanable funds, because a. in our m

Gelneren [198K]

Answer:

a. in our model of the loanable funds market, we define "loanable funds" as the flow of resources available to fund private investment.

Explanation:

Given that, government budget deficit is a term that describes a situation whereby the amount of government expenses is greater than the amount of government revenue over a given period of time. And at the same time, the loanable fund is the money available to find private investment

Hence, the right answer to the question is option a. in our model of the loanable funds market, we define "loanable funds" as the flow of resources available to fund private investment. Because, the insufficient revenue, will lead to little or no availability of resources to find private investment.

3 0

3 years ago

Employee _______________ more readily occurs when employees are informed of the change and are educated on the reason for the ch

insens350 [35]

Employee buy-in more readily occurs when employees are informed of the change and are educated on the reason for the change.

An employee is a person who is paid to work for an individual or company. A worker does not have to work full time to be considered an employee. You just need to be paid for the work by your employer (the person or company that pays your wages).

The definition of employee is someone who works for another person or company for wages or other agreed remuneration. An example of an employee is someone employed by McDonald's who is paid a fixed amount for each hour worked.

Learn more about Employee here:brainly.com/question/1190099
#SPJ4

6 0

1 year ago

The end goal of the Executive order is to provide what to the patients

dmitriy555 [2]

Death or happiness or even sadness or maybe life or a happy feeling

6 0

3 years ago