XOR
Description
Returns the logical Exclusive Or result for the specified conditions.
Syntax
XOR(
value1
, [
value2
], ...)
- value1: One or more conditions to evaluate.
- value2: One or more conditions to evaluate.
Example
Formula | Result |
|---|---|
=XOR(2>1,5<10) | FALSE |
=XOR(1<2,5>10) | TRUE |
=XOR(1>2,5>10) | FALSE |