Which formula would display 10% in cell C3 if the customer order quantity is over 300, and 0% if not.
A. =IF(C3&gt;300,10%,0%)
B. =IF (B3&gt;300, 10%, 0%)
C. =IF (B3&gt;300, 0%, 10%)
D. =IF (B3&lt;300, 10%, 0%)
Answer:B
Which formula would display 10% in cell C3 if the customer order quantity is over 300, and 0% if not.
A. =IF(C3&gt;300,10%,0%)
 B. =IF (B3&gt;300, 10%, 0%)
 C. =IF (B3&gt;300, 0%, 10%)
 D. =IF (B3&lt;300, 10%, 0%)
