XOR function.Conditional judgment of exclusive OR.(Microsoft Excel)
A companion to the AND and OR functions, it retrieves the exclusive OR.
XOR is TRUE only if all of the logical expressions in the argument are TRUE or all are FALSE, otherwise it is FALSE.
How it works
XOR(logical1 to 254)
| Argument | Omission | Specify |
|---|---|---|
| logical1 to 254 | logical1 is required. | Up to 254 conditional expressions or logical values that are TRUE or FALSE can be specified. At least one is required, but two should be specified for practical use. |
Example Results
This is an example of executing the XOR function and comparing it with the AND and OR functions.
Spill
To "Spill" the function, use the BYROW and BYCOL functions.
=BYROW(A1:B4,LAMBDA(r,XOR(r)))
=BYCOL(F1:I2,LAMBDA(r,XOR(r)))
---