Perform exclusive OR
=XOR(logical1, [logical2], ...)
| Parameter | Description |
|---|---|
logical1 |
An expression, constant, or reference that evaluates to TRUE or FALSE. |
logical2 |
[optional] An expression, constant, or reference that evaluates to TRUE or FALSE. |
In the example shown, the formula in D5, copied down, is:
=XOR(B5,C5)
In this example, XOR is given a range with five values in a single argument instead of five separate arguments. The formula in G6 copied down is:
=XOR(B6:F6)