kmingo2020 kmingo2020
  • 21-11-2021
  • Computers and Technology
contestada

In cell B17, enter a formula that uses the IF function and tests whether the total sales for January is greater than or equal to 200000?

Respuesta :

charlief22
charlief22 charlief22
  • 22-11-2021

An if statement in excel is written in the form:

=if(statement/test, value if true, value if false)

When calculating if a value is greater or equal to, the sign that can be used is:

>=

So putting this into a formula:

=(if B17 >= 200000, "Yes", "No")

Hope this helps!

Answer Link

Otras preguntas

why are average temperatures higher at the equator than near the poles?
The molar mass of calcium is 40.08, oxygen is 16.0, and hydrogen is 1.01. What is the mass of one mole of calcium hydroxide (Ca(OH)2)?
What pressure, in millimeters of mercury (mm Hg), is equivalent to 2.13 atmospheres
What is the fraction for 2.3125? Improper fraction form
A force of 34.5 newtons is applied to an object at an angle of 45 º with the horizontal. What is the force acting on the object in the horizontal direction?
What was the extent of the Russian Empire's expansion between the 9th century and the end of the 17th century?
Which of the following is an example of kinetic energy? a can of paint sitting at the top of a ladder a dog running down the street a bird perched on a wire a p
5. Use inductive reasoning to find the next term in the sequence 0, 1, 1, 2, 3, 5, 8 … HELP PLEASE!!!
HOW CAN 5 PEOPLE equally SHARE 4 BROWNIES IN FRACTION TERM?
Which compound has the strongest hydrogen bonding between its molecules? 1. HBr 2. HF 3. HCl 4. HI