1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Troyanec [42]
3 years ago
15

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
Which of the following is a variable expense?
Neporo4naja [7]

Answer:

car insurance

Explanation:

6 0
2 years ago
Read 2 more answers
Exxon has the following capital structure: the firm issued 6 million shares of common stock with the stock price in c), the firm
lesantik [10]

Answer: some data is missing but I was able to find it online and that helped me resolve the problem .

answer : WACC =  15.76%

Explanation:

Given that the common stock price = $9 ( as seen in option C not attached above )

value of common stock = $9 * 6 * 10^6 = $54,000,000

cost of common equity = 10.93%

current preferred stock price = $6

value of preferred stock = $6 * 1,500,000 = $9,000,000

hence the cost of the preferred equity = $4.5 / $6 = 0.75 = 75%

interest rate of debts = 6.5%

value of debit = $25,000,000

Corporate tax rate = 25%

∴ The cost of the debit after tax = 6.5% * ( 1 - 25)% = 4.88%

The Total value = value of common stock + value of preferred stock + value of debit

 = 54,000,000 + 9,000,000 + 25,000,00 = $88,000,000

<u>Finally the weighted average cost of capital ( WACC )</u>

[weight of debt * cost of debt after tax ] + [ weight of common equity * cost of common equity ] + [weight of preferred * cost of preferred ]

= [ (25/88) * 4.875 ] + [(54/88) * 10.933] + [ (9/88) * 75 ]

= 15.76%

3 0
2 years ago
Which statement below is​ FALSE? A. ​Mintzberg's notion of​ "crafting" strategies embodies the artistic​ model, which suggests t
OlgaM077 [116]

Answer:

D

Explanation:

3 0
3 years ago
Justin, a human resources manager for xyz company, commits 20% of this year's budget to develop a new program for valuing divers
rewona [7]
Human Resource Manager
4 0
3 years ago
Terrance is very skilled in biological research and the scientific principles guiding his work. He is also punctual, well-organi
Veronika [31]

Answer:

<em>Transferable skills</em>

Explanation:

Transferable skills <em>include all abilities that you may have, that are helpful to companies throughout different employment and sectors. </em>

They may involve abilities that companies pursue in powerful applicants such as versatility, organisation, sportsmanship or other characteristics.

These skills can be used when searching for a new job to place your previous experience, especially if it's in another sector.

5 0
3 years ago
Other questions:
  • Assume that Diego has S400 per month to divide between playing paintball and playing golf. Assume that playing paintball costs S
    13·1 answer
  • When preparing a speech introduction, you should usually?
    9·1 answer
  • On december 1, 2016, escobar consulting, which uses a calendar year as its fiscal year, signs a $4,000, 12%, four-month note pay
    12·1 answer
  • Your broker calls to offer you the investment opportunity of a​ lifetime, the chance to invest in​ mortgage-backed securities. T
    10·1 answer
  • In what form of media relations is the point of initiation the organization rather than an external entity?
    12·1 answer
  • Last month when Holiday Creations, Inc., sold 37,000 units, total sales were $315,000, total variable expenses were $239,400, an
    9·1 answer
  • In a private club, a member is paying for: The service of the alcoholic beverage. The alcoholic beverage. A membership fee. None
    11·2 answers
  • Determine the total equivalent units for direct materials, assuming that the first-in, first-out method is used to cost inventor
    9·1 answer
  • BE18.8 (LO 2) Presented below are three revenue recognition situations. a. Groupo sells goods to MTN for $1,000,000, payment due
    5·1 answer
  • Can you empathize with customers concerns.
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!