<< Click to Display Table of Contents >> XOR (logical XOR function)

Syntax:

XOR(Value1 [, Value2, Value3 ...])

Description:

XOR ("exclusive or") returns the logical value TRUE if an odd number of the arguments are TRUE, otherwise it returns FALSE.

This function is often used with only two arguments. Here, the following applies: If either one or the other argument is TRUE, it returns TRUE. On the other hand, if both are TRUE or both are FALSE, it returns FALSE.

Compatibility notes:

Microsoft Excel supports this function only in version 2013 or later. The function is unknown in older versions.

Example:

XOR(TRUE, TRUE) returns FALSE

XOR(TRUE, FALSE) returns TRUE

XOR(FALSE, TRUE) returns TRUE

XOR(FALSE, FALSE) returns FALSE

See also:

OR, AND, NOT