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

Rapid rental car charges a $40 rental fee, $15 for gas, and $0.25 per mile driven. For the same car, Capital Cars charges $45 for rental and gas and $0.35 per m
Two students are in a baseball game. The first student hits a ball very hard and it has a greater acceleration than the second student who bunts the ball lightl
Can someone help me with 5 if you also do 5 and 6 then u will get a brainlist from me!
8 different forms of protected freedom of speech
urgent plzz help meeee thx I HAVE EXAMEEE
what are the difference between clinical and laboratory thermometer?​
Which is the correct algebraic expression for each phrase? 2.5 times as many pages.a. 2.5pb. p+2.5c. 2.5÷pd. p-2.5
Fill in the blank with the French word that best completes the sentence. La fille de ma soeur est O ma nièce O ma tante O ma fille O ma cousine
X3 + 2x + 3 =18 What is x?
How many grams of hydrogen are produced from the reaction of 8.50 moles of zinc with an excess of hydrochloric acid?Zn+2HCl = ZnCl2+H2​