XOR function
Summary
Returns a logical exclusive OR of all arguments
Syntax
XOR(logical1, [logical2],…)
The XOR function syntax has the following arguments.
• Logical1, logical2,… Logical 1 is required, subsequent logical values are optional. 1 to 254 conditions you want to test that can be either TRUE or FALSE, and can be logical values, arrays, or references.
• Logical1, logical2,… Logical 1 is required, subsequent logical values are optional. 1 to 254 conditions you want to test that can be either TRUE or FALSE, and can be logical values, arrays, or references.
Example
=XOR(3>0,2<9)
=XOR(3>12,4>6)
=XOR(3>12,4>6)