XOR Function Explained

The XOR Function in Microsoft Excel returns a logical TRUE if one, and only one, of the provided arguments is TRUE. If both arguments are TRUE or both arguments are FALSE, the function returns FALSE.

XOR Function Syntax

XOR(logical1, [logical2], ...)

  • logical1: The first logical value or expression to evaluate.
  • logical2: (optional) Additional logical values or expressions to evaluate.