XOR
True when an odd number of conditions are true. With two conditions: exactly one.
Group: Logical
Syntax
XOR(test1, [test2], ...)Example
Exampleexcel
True when an odd number of conditions are true. With two conditions: exactly one.
Group: Logical
XOR(test1, [test2], ...)