Exclusive OR (XOR)
Also called XOR or exclusive disjunction.
Exclusive OR (XOR) is a logical rule that is true when exactly one of two statements is true. It is false when both are true or both are false. Businesses use it in spreadsheet checks and rules that require one choice.
"XOR decision making" is an informal label, not a standard business framework. It refers to applying this either-but-not-both rule to a decision.
How it works
Ordinary OR accepts either statement or both. XOR rejects "both" as well as "neither."
For two TRUE/FALSE cells, Excel uses:
=XOR(A2,B2)
The equivalent logical formula is:
(A OR B) AND NOT (A AND B)
With more than two inputs, Excel's XOR returns TRUE when an odd number of inputs are TRUE. It is not an "exactly one" test for a longer list.
Choosing one $6,000 project from a $10,000 budget
A team must choose exactly one project this month: a contractor engagement or an ad campaign. Either costs $6,000, and the available budget is $10,000.
| Choose contractor? | Choose campaign? | Total cost | XOR accepts? |
|---|---|---|---|
| No | No | $0 | No |
| Yes | No | $6,000 | Yes |
| No | Yes | $6,000 | Yes |
| Yes | Yes | $12,000 | No |
Either accepted choice leaves $10,000 − $6,000 = $4,000. Choosing both costs $12,000, which exceeds the budget by $2,000.
But XOR is a selection rule, not a budget test. Choosing neither costs nothing and stays within budget, yet fails the requirement to select exactly one. If doing nothing is acceptable, the rule should be "at most one," not XOR.
Questions people ask
Is ⊕ XOR?
Yes. In Boolean logic, A ⊕ B means A XOR B. By contrast, ∧ means AND and ∨ means inclusive OR, which allows both statements to be true.
