Exclusive OR (XOR)

Also called XOR or exclusive disjunction.

Business basics1min read

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 costXOR accepts?
NoNo$0No
YesNo$6,000Yes
NoYes$6,000Yes
YesYes$12,000No

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.

Sources

  1. Microsoft Support, "XOR function."