Returns the exclusive OR of all arguments.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
XOR(logical1, [logical2], …)The XOR function returns TRUE if an odd number of the provided arguments evaluate to TRUE, and FALSE otherwise. It is useful for determining if exactly one of several conditions is met.
=XOR(TRUE, TRUE)Result: FALSE
Since there are two TRUE values (an even number), the result is FALSE.
=XOR(TRUE, FALSE, FALSE)Result: TRUE
Since there is only one TRUE value (an odd number), the result is TRUE.
The XOR function will return FALSE because zero is an even number.