XOR function
First
The first parameter.
Other
Additional parameters.
Returns
TRUE if, and only if, an odd number of parameters are TRUE and FALSE otherwise.
Returns TRUE if an odd number of parameters are TRUE and FALSE otherwise. XOR(TRUE, FALSE, TRUE)XOR(TRUE; FALSE; TRUE) returns FALSE, because there are two TRUE parameters, an even number.
Use XOR, AND, OR and NOT in conjunction with IF to express logical conditions.
"XOR" stands for "exclusive or." When applied to exactly two parameters, it returns TRUE if the parameters differ and FALSE otherwise. These formulas both return TRUE:
These formulas return FALSE:
Examples
Returns TRUE, because the parameters differ.
Returns FALSE, because the parameters do not differ.
Returns FALSE, because the array elements do not differ.
Returns TRUE, because five array elements and parameters are TRUE, and five is an odd number.