[]
This function returns logical exclusive OR of specified numbers.
XOR(logical1, [logical2],…)
This function has these arguments:
Argument | Description |
|---|---|
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. |
This function returns TRUE (or 1) when number of true inputs is odd; otherwise, returns FALSE (or 0) when number of true inputs is even.
XOR(3>0,2<9) gives the result FALSE