TRUE Lookup

XOR

XOR —

Synopsis

XOR(b1, b2, ...)

Description

XOR implements the logical exclusive OR function: the result is TRUE if an odd number of the values evaluated to TRUE.

b1 through bN are expressions that should evaluate to TRUE or FALSE. If an integer or floating point value is provided, zero is considered FALSE and anything else is TRUE.

  • If the values contain strings or empty cells those values are ignored.
  • If no logical values are provided, then the error #VALUE! is returned.

Examples

XOR(TRUE,FALSE) equals TRUE.

XOR(3>4,4<3) equals FALSE.

See also

OR, AND, NOT.

TRUE Lookup