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 did people immigrate to the United States in the late 1800s?
please explain how to solve this  On Monday,it took Helen 3 hours to do  a page of science homework exercises.The next day she did the same number of exercises
A pencil measures 14 cm long. How many millimeters long is it?
''Life in a city is more rewarding than life outside a city."List two or three arguments in favor of this opinion and two or three arguments opposing this opini
why did people immigrate to the United States in the late 1800s?
''Life in a city is more rewarding than life outside a city."List two or three arguments in favor of this opinion and two or three arguments opposing this opini
whats the most accurate estimation of 65+77
which of the following represents the most accurate estimation of 38+23
why did people immigrate to the United States in the late 1800s?
which of the following represents the most accurate estimation of 38+23