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

The figure is the net for a rectangular prism. What is the surface area of the rectangular prism represented by the net? Enter your answer in the box. cm² An
what is the lcm of 5,6 and 7​
Three friends are sharing equally 3/4 of a pizza. Each person receives 1/4 of the pizza.
Kelli has a family photograph with a width of 6 in and a height of 8 in. She wants to enlarge the photograph so that it’s width is 15 in.what will the height of
Kewane Childs, a 44-year-old female, has a history of smoking cigarettes for 15 years; she quit last year. Kewane sees Dr. Cope for a dry cough, hoarse voice, a
1. Who led the revolt against the English king?
At 20°C, how many grams of potassium nitrate can be dissolved in 100 g of water?
Please help me I will give Brainlest
what organ follows the stomach in the digestive system​
Today is your 21st birthday and you just decided to start saving money so you can retire early. Thus, you are going to save $500 a month starting one month from