If A7=21, which of the following =IF statements would produce the result of "Much Greater"? A)=IF(A714,"Greater",IF(A720,"Much Greater","Not Greater than 20")) B)=IF(A720,"Much Greater","Not Greater than 20")) C)=IF(A720,"Much Greater","Not Greater than 20")) D)=IF(A720,"Much Greater","Not Greater than 20")

Question

If A7=21, which of the following =IF statements would produce the result of "Much Greater"? A)=IF(A7>14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")) B)=IF(A7<50,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")) C)=IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")) D)=IF(A7<14,"Greater",IF(A7>20,"Much Greater","Not Greater than 20")

Quizplus · Accepted Answer

The correct choice is C because it first checks if A7 is less than 14, which it isn't since A7=21, so it moves to the next IF statement which checks if A7 is greater than 20. Since A7 is indeed greater than 20, the result is "Much Greater". Choices A and B do not produce "Much Greater" because their conditions are not met in the same way, and D is identical to C but seems to have a typographical error at the end.

If A7=21, Which of the Following =IF Statements Would Produce