Returns the exclusive OR of all arguments.
Syntax
XOR(logical1, [logical2], …)Argumente
logical1erforderlich
The first condition or value you want to test.
logical2optional
Additional conditions or values to test, up to 254.
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)→FALSESince there are two TRUE values (an even number), the result is FALSE.
=XOR(TRUE, FALSE, FALSE)→TRUESince there is only one TRUE value (an odd number), the result is TRUE.
Select a cell
Click on the cell where you want to display the result.
Enter the function
Type =XOR( followed by your logical arguments separated by commas.
Complete the formula
Close the parenthesis and press Enter to see the result.
The XOR function will return FALSE because zero is an even number.