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

Find the quotient of 11,906 divided by 312
Which statement about how Edgar Degas showed movement in artworks is true? He used bold, electric colors next to each other.He used mirror-like brushwork to app
why is it important to cite your sources properly
how does the speaker excrise power over a committee​
Review the map above. Why is the black line significant in American history
According to the lesson, which of the following countries has declared itself nuclear free? A. The US B. Belgium C. New Zeland D. Italy
Help me please I am stuck on this question
Need help for this question
no one is helping me please help me​
The atmosphere: has weight protects us from harmful sun rays keeps the earth warm all of the above