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 11 months ago
Did this page help you?