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 most recent financial statements for Assouad, Inc., are shown here: Income Statement Balance Sheet Sales $ 11,100 Current as

Pachacha [2.7K]

Answer:

EXTERNAL FINANCING NEEDED IS $383.736

Explanation:

For calculating the external financing , we first have to take out what the sales , cost , asset , liability will be when the sales of the company increases by 17%, so now we have to calculate all the values -

SALES = $11,100 X 1.17 ( multiplying by 17% because of increase in sale)

= $12,987

COST = $7900 X 1.17 (multiplying by 17%)

= $9243

INCOME BEFORE TAX = SALES - COST

= $12,987 - $9243

= $3744

TAXES AT 24% ON TAXABLE INCOME OF $3744

= .24 X $3744 =$ 898.56

Now subtracting this amount from taxable income

$3744 - $898.56 = $2,845.44

Next step would be of paying dividend payout ratio from it

40% of $2,845.44 = .40 x $2845.44

= $1138.176

RETAINED EARNINGS = Taxable income - Dividend payout

= $2845.44 - $1138.176

= $1707.264

NOW TOTAL ASSETS WOULD BE = $15,600(5400+10200) X 1.17

= $18,252

IT IS GIVEN IN THE QUESTION THAT COST, ASSET, LIABILITY(CURRENT) ARE ALL PROPORTIONAL TO SALES.

CURRENT LIABILITY = $3300 X 1.17

= $3861

TOTAL COST = LONG TERM LIABILITY + CURRENT LIABILITY

=$4820 + $3861

= $8681

TOTAL EQUITY EQUAL = $7480 + $1707.264 (RETAINED EARNINGS)

= $9187.264

EXTERNAL FINANCING = ASSET - LIABILITY - EQUITY

= $18,252 - $8681 - $9187.264

= $383.736

4 0

3 years ago

Chris Cole is a salesperson for Green Scene Lawn Care products. Chris' job requires him to sell Green Scene products, but he is

AVprozaik [17]

Answer:

A) True

Explanation:

Multilevel marketing is used by companies that engage in direct sales marketing and where each new salesperson or distributor must recruit more sales people to expand their activities. Some of the most famous multilevel marketing firms in the US are Avon and Herbalife.

The salesperson or distributor earns a fraction of the sales commissions that his/her recruited sales people sell. It is called the distributor's downline, and is shaped like a pyramid. In some countries this type of business is illegal because it works like a Ponzi scheme where new salespeople are recruited every time and in order to start working they must buy a certain amount of products. So a large percentage of the sales are made to other salespeople instead of customers.

5 0

3 years ago

If two individuals are licensed in the same line with two different companies join together to sell a policy, the commission can

NISA [10]

<h3><u>Answer:</u></h3>

The commission can be shared between the two agents.

<h3><u>Explanation:</u></h3>

Many times different companies collaborate with each other to sell a particular policy to maximize their profits. When there are two agents licensed in the same line and when the two companies collaborate to sell a policy then the commission is shared between the agents.

This is because they will work together for the profits and that when the two companies collaborate they become one to sell the policy. The agents work together and the commission is given to them as a whole. This is a common practice when two companies work together.

4 0

3 years ago

Which california governor was instrumental in changing the executive bureaucracy from a spoils system to a merit system?

WINSTONCH [101]

Republican Governor Hiram Johnson was the California governor who was instrumental in changing the executive bureaucracy from a spoils system to a merit system.

A spoils system refers to a system of patronage in which the victorious candidate or party in an election gives public offices to their supporters as reward and incentive.

It was a common phenomenon in the United States, until a civil service reform movement led to passage of the Pendleton Act of 1883, which instituted merit-based appointments to offices at the federal level.

Hiram Johnson was a former Governor of California between 1917 to 1945. He was credited with many progressive reforms, among which was ensuring the executive bureaucracy operated on the basis of merit and not political patronage.

To learn more about Hiram Johnson: brainly.com/question/8407551

#SPJ4

5 0

2 years ago

Assuming that the car was stolen prior to delivery to abc motors and without the knowledge of any representative of abc motors,

tamaranim1 [39]

I believe in this case that ABC motors is the customer and the car was still being delivered to their office. Therefore the correct answer to this is:

The title of ABC motors would be “Void”

<span>This is considered right away as Void since there was no information or any knowledge on the part of ABC motors about the stolen car. </span>

7 0

3 years ago