All of the following statements are TRUE about nested IF functions EXCEPT:
A)Each nested function needs a pair of parentheses.
B)Excel color codes parentheses to indicate which parentheses are paired.
C)Nested IF functions permit more than two outcomes.
D)The outcome of a nested IF function is limited to numeric or text values.

Question

Quizplus · Accepted Answer

The statement "The outcome of a nested IF function is limited to numeric or text values" is not true. Nested IF functions can produce a variety of outcomes including logical values, dates, and even more complex formulas or functions.

All of the Following Statements Are TRUE About Nested IF