XOR

Returns the logical Exclusive-OR of all the given Boolean values.

Syntax:

XOR(list)

Returns the logical Exclusive-OR of all the Boolean values in the list, which may be an array, a range of cells, or a comma-separated list of values.

Example:

XOR(A1, A2)

where the cell values are TRUE and TRUE will return the Boolean value FALSE.

Added in 2.00.