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

15 POINTS AND BRAINLIEST (IF CORRECT)!! Which statements describe hormones in plants? Check all that apply. Cutting stems can stimulate hormones to start latera
What are you doing for thanksgiving? 1 paragraph plz
What rules are used to balance a chemical equation?
How can having a source connected to a newsworthy situation be a bad thing? A. The source may know too much information B. The source may want free advertisin
Please help ASAP I will give brainliest
Use substitution to solve the system. x = 3y - 12 5x + 3y = 30 I would appreciate answers
Someone please help me answer this question ​please and thank you.​
I need help dividing these decimal numbers 1. 4.75 ÷ 5 = 2. 0.5 ÷ 2 = 3. 10.26 ÷ 2 = 4. 0.36 ÷ 9 = 5. 0.4 ÷ 20 = 6. 3.5 ÷ 7 = 7. 0.88 ÷ 4 = 8. Kari is making c
An equation uses the symbol. True False
If the US enters the war, how would this affect the US domestically?