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

How should factory overhead variances be treated in a journal entry to apply factory overhead?

AURORKA [14]

Factory overhead variances should be broken out into their individual components and reported separately as either debits or credits to their individual variance accounts should factory overhead variances be treated in a journal entry to apply factory overhead

Credit is generally defined as an agreement between a lender and a borrower. Credit also refers to the creditworthiness or credit history of an individual or entity. In accounting, loans can reduce assets or increase liabilities, and can reduce expenses or increase income.

One credit is equivalent to a 30-second voice message. A voice message can be recorded for up to 120 seconds. The longer the voice message, the more credit you will get for shipping per phone number. 1-30 seconds = 1 credit per phone number.

An example of credit is a celebration for graduating from medical school while working two jobs. Examples of loans are amounts that are available in a bank account or credited to a checking account. An example of credits is the number of English courses required for a degree.

Learn more about credits here

brainly.com/question/13375913

#SPJ4

5 0

2 years ago

Ken, a transaction broker, worked with both the buyer and seller in the sale of a home. The sale went well and it closed on time

vovangra [49]

Ken, the agent, violated the law of agency
In this particular instance, when Ken told the the buyer that the seller would take a lower price than what was on the listing in order to close the sale faster and then told the buyer exactly which price they should offer, Ken, who is the agent, has now violated the law of agency

6 0

3 years ago

What did congress do to protect consumers from monopolies, false advertising, and dishonest labeling? it established the america

alexandr1967 [171]

<span>In order to protect consumers from unfair business practices such as false advertising, dishonest labeling and monopolies, the federal government created the Federal Trade Commission to establish and enforce regulations protecting consumers from unfair and dishonest sales practices.</span>

4 0

3 years ago

Read 2 more answers

What is a product item?

Vsevolod [243]

Answer:

Explanation:

A product item is a specific version of a product that can be designated as a distinct offering among an organization's products. A product line is a group of closely related products offered by an organization.

5 0

2 years ago

Anna-Marie senses that one of her employees feels excluded from the rest of the group. She is surprised by this, as she believes

cricket20 [7]

The best action that Anna-Marie should take next is <u>A- She should talk</u> to the employee to understand their perspective.

Talking to the employee will reveal if they are out-group members and enable Anna-Marie to understand their views.

<h3>Who is an out-group member?</h3>

An out-group member is an individual in an organization who does not identify themselves as part of the group or unit.

An out-group member does not pursue the same goals as other group members and most times feels excluded from the group.

<h3>Answer Options:</h3>

A- She should talk to the employee to understand their perspective.

B- She should redistribute the company policy describing inclusion expectations.

C- No action is required; she is already acting ethically.

D- She should start documenting her efforts at inclusion.

Thus, the best action that Anna-Marie should take next is <u>A- She should talk</u> to the employee to understand their perspective.

Learn more about out-group members at brainly.com/question/7548841

3 0

1 year ago