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

This one too?!? I need the answer!
Chuck is making a scale drawing of his house. He is using the scale 1 inch = 5 feet. The dimensions of his actual house are 45 feet by 75 feet. What are the dim
PLEASE HELP ASAP Which had the biggest impact on economic growth in Sumerian city-states? A)writing literature B)building ziggurats C)trading between city-stat
Whom will you talk to if you are feeling overwhelmed or discouraged? How will this person help you? Be specific and detailed.
Who wrote the Bill of Rights? © James Madison Alexander Hamilton o Thomas Jefferson George Washington
1. Which TWO statements best identify the central ideas of th article? A soil health can be improved with nutrient-rich fertilizers
5. For a plant, sunlight is an example of
Which of the following equations is of a parabola with a vertex at (1, 2)? O y = (x - 1) 2 - 2 y = (x - 1)2 + 2 O y = (x + 1)2-2 O y = (x + 1)2 + 2
A pulley moves 8.67 feet of rope per minute. How many feet of rope will the pulley move in 6 minutes?
Which line has no slope? Line a Line b Line c Line d