Solved

If Cell B7 Contains a Value That Is Greater Than

Question 76

Multiple Choice

If cell B7 contains a value that is greater than 20,and "ORDER" will be displayed when the logical test is TRUE,which of the following contains the correct IF function syntax?


A) =IF(B7<20, "ORDER", "OK")
B) =IF(B7<20, "OK", "ORDER")
C) =IF(B7>20, "ORDER", "OK")
D) =IF(B7>20, "OK", "ORDER")

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions