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

URGENNTTT !!! ITS EASY BUT I NEED CLARIFICATION
Straight-line depreciation is used for the 10 boats purchased on April 2 for $60,000. The useful life for these assets is five years and there is no salvage val
With a partner, reread the excerpt from We Need to Talk and look for evidence of fallacious reasoning. Provide evidence for why you think the reasoning is fall
How do I do this, the image is the question
Where do you think Alison acquired this infection? What is an infection acquired in this manner called?
What themes are explored in “my forbidden face” by latifa
Most animals can survive without food for a longer time than they can survive without water. Why is water so important to animals? Why can an animal survive wit
Find the value of each variable
En el taller de arte de la escuela se cuenta con 98 botes de pintura amarilla, 70 bo tes de pintura roja y 14 botes de pintura azul. Si el taller debe distribui
message How does the Gulf Stream affect weather patterns? It moves air, which causes wind to blow. It blocks air, which stops wind from blowing. It cools air,