XOR

Returns true if an odd number of the given expressions/values are true, and false otherwise

Syntax

=XOR(expr)

=XOR(expr1, expr2, ..., exprN)

Arguments

Argument	Type	Description
exprN	Boolean	The value to use

Examples

=XOR(false, false) → false

=XOR(false, true) → true

=XOR(true, true) → false

=XOR(false, false, true) → true

=XOR(true, false, true) → false

=XOR(1 = 1, 2 = 2) → false

=XOR(@"Property 1" = 1, @"Property 2" >= 4) → true
In this example “Property 1” is set to 1 and “Property 2” is set to 3. Because only one of the provided expressions evaluates to true, the entire function returns true.