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(B720, "OK", "ORDER")

Question

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")

Quizplus · Accepted Answer

The logical test in the IF function is checking if the value in cell B7 is greater than 20, so the correct syntax should be IF(B7>20, "ORDER", "OK"). Option A and B are checking if the value is less than 20, which is incorrect. Option D is switching the output values, so it would display "OK" instead of "ORDER" when the value in cell B7 is greater than 20.

If Cell B7 Contains a Value That Is Greater Than