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.
Updated 3 months ago