XOR
Returns a logical exclusive OR of all arguments.
LogicalLogic & Conditions
What it does
Returns TRUE if an odd number of arguments are TRUE.
Syntax
XOR(logical1, [logical2], ...)
Arguments
logical1(logical) — Condition.
Examples
Exclusive OR
TRUE only if one is TRUE.
FORMULA
=XOR(TRUE, FALSE)
RESULT
true
SAMPLE DATA
| A | |
|---|---|
| 1 | Res |
| 2 |