This behavior is sometimes referred to as “exclusive OR”, meaning only one result can be true.
Note: with more than two criteria, XOR behavior changes, asexplained on the XOR function page.
If neither is TRUE, XOR also returns FALSE.
One or the other not both
To check two items with exclusive OR (one or the other, but not both), you can use the XOR function. In the example shown, E5 contains the following formula: =XOR(C5="x",D5="x") This formula returns TRUE when either coffee or tea has an "x". It returns FALSE if both coffee and tea have an "x", or if neither coffee nor team has an "x".
