Nathan wants TRUE to be elicited if either of the statements are true,and FALSE if both are true.Which of the following formula can he use to ensure that?
A) =IFNA(...)
B) =XOR(...)
C) =IFERROR(...)
D) =TRUE OR FALSE(...)

Question

Quizplus · Accepted Answer

The function XOR (exclusive or) returns TRUE if only one of the arguments is true, and FALSE if both are true or both are false. In this case, if either of the statements is true, XOR will return TRUE, which is what Nathan wants to elicit.

Nathan Wants TRUE to Be Elicited If Either of the Statements