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

A firm has a market value equal to its book value. Currently, the firm has excess cash of $900 and other assets of $5,100. Equit

Harrizon [31]

Answer:

$850

Explanation:

Price per share = $6,000 ÷1,000 = $6

Number of shares repurchased = $900 ÷$6 = $150

New number of shares outstanding = $1,000 - $150 = $850

Therefore $850 shares of stock will be outstanding after the stock repurchase is completed

8 0

3 years ago

Identify the features of stocks and bonds

ch4aika [34]

Explanation:

How to "buy at wholesale, sell at retail" like financial institutions

How to navigate today's increasingly volatile markets and manage risk

Common mistakes of the novice investor and how to reduce them

How you can time the market by waiting for opportunity to come to you

A rules-based strategy for trading in any market and any asset class

3 0

3 years ago

Ceteris paribus, if the corn crop is 15 percent larger this year than it was last year, farmers will have to ________ the price

Yuki888 [10]

Answer:

Reduce and more than 15 percent

Explanation:

As Inelastic Demand state that the percentage change in quantity demanded is less than the percentage change in price. Therefore, if the crop is 15 percent higher, farmers will have to reduce the cost of corn by 15 percent to sell the new crop. We know that supply and price share an inverse relationship to reduce sales as supply increases and new crops grow.

7 0

3 years ago

The goal of global market segmentation is to break down a new foreign market for a product or a service into different groups of

Lunna [17]

The goal of global market segmentation is to break down a new foreign market for a product or a service into different groups of consumers so the firm can tailor its marketing mix to each individual segment.

More about marketing mix:

The marketing mix is the collection of activities, or methods, that a business employs to sell its brand or merchandise. A typical marketing mix is comprised of the four Ps: price, product, promotion, and place. Today, however, the marketing mix is progressively including several more Ps as essential mix components, such as Packaging, Positioning, People, and even Politics.

Price mix is the cost incurred by the company to deliver a product to the customer. Product mix exemplifies the nature of the good that the company is selling to the customer. Place mix is the method used to distribute the goods at a time and place that are convenient for the consumer.

Learn more about marketing mix here:

brainly.com/question/14410009

#SPJ4

5 0

2 years ago

The government of Ruritania has implemented many programs that promote equality, but has become concerned about the very slow ra

IceJOKER [234]

Answer: b. reduce taxes and cut back on some social programs

Explanation:

When the Economy is not doing well, Social programs are usually targeted as they usually take a lot of money from the Government's coffers.

It is also a generally held view that reducing taxes as a Fiscal policy can help stimulate the Economy by leaving the public with more funds to invest in and spend on the Economy.

The Government of Ruritania is therefore most likely to combine reducing Social programs as well as reducing taxes. This will have the effect of leaving the Government with some money as it loses revenue from taxes whilst also enabling the public to have more money to invest and to spend which will then lead to Economic growth.

8 0

3 years ago