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

Someone please help me out
Business services ordered a chair that cost $220.59. Upon arrival they received an invoice for $261.47. If the California sales tax rate is 7.9% what is the cos
PLEASE HELP!!! Given triangle QRS is congruent to triangle TUV, QS = 3v + 2 and TV = 7v - 6, find the length of QS and TV.
Please help me. I am stuck.
Geological evidence like fossils can be used as evidence for evolution. Which statements below correctly explain how? Choose all that apply. The relative age
If a child between the ages of 13 and 17 is charged with committing any of these crimes, he/she will be A) tried in Juvenile by a State Court judge. B) held in
Name three factors that are important in promoting venous return
Considering the wavelengths of light shown below, the pigments in the granum absorb mainly in which range? A. green, which is why plants are green B. the infrar
Name three factors that are important in promoting venous return
Need help with this question please anyone