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
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:

D

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
Other questions:
  • For which of the following goods is the income elasticity of demand likely highest?
    7·1 answer
  • Which of the following scenarios is an example of using potentially copyrighted material?
    6·2 answers
  • If the expected path of interest rates on one-year bonds over the next five years is 2%, 4%, 3%, 2%, and 1%, the expectations th
    5·1 answer
  • True or false: as a patient, your doctor must have you sign a hipaa consent and release form to share your ephi or phi with insu
    13·1 answer
  • Which example best demonstrates the capabilities of e-mail?
    15·2 answers
  • Dartford Company reported the following financial data for one of its divisions for the year; average investment center total as
    9·1 answer
  • Economists use the word marginal to mean an extra or additional benefit or cost of a decision. An optimal decision occurs when _
    12·1 answer
  • A corporation can trade its stocks in the financial markets as ____.
    10·1 answer
  • The May transactions of Whispering Winds Corp. were as follows. May 4 Paid $690 due for supplies previously purchased on account
    10·1 answer
  • *Will award Brainliest if correct!*
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!