All of the following statements are TRUE about the IF function EXCEPT:
A)The [value_if_false] argument may be omitted from the IF function.
B)The IF function is the most common logical function.
C)The TRUE argument of the IF function is optional.
D)Cell references listed in the IF function must be capitalized.

Question

Quizplus · Accepted Answer

The IF function does not require cell references to be capitalized. Choices A, B and C are true statements about the IF function.

All of the Following Statements Are TRUE About the IF