XOR

Calculates the logical Exclusive-OR of a number of Logical values.

Syntax:

XOR(list)

Returns the logical Exclusive-OR of all the Logical values in the list.

list 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 Logical value FALSE.

Revisions:

This function was added in 2.00.