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, \ok\, \order\) d. =if(b7<20, \order\, \ok\)

Explanation:

Step1: Analyze the condition

We want "ORDER" to be displayed when B7 > 20. In an IF - function, the first argument is the logical test, the second is the value if true, and the third is the value if false.

Step2: Match with options

Option A has the logical test B7>20 and "ORDER" as the value if true and "OK" as the value if false which meets our requirement.

Answer:

A. =IF(B7>20, "ORDER", "OK")