Excel XOR Function (Exactly One TRUE) – Examples & Practice
Practice the Excel XOR function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Return TRUE only when exactly one of these is TRUE: A2>=85 or B2>=90.
Formula Syntax
=XOR(logical1, [logical2], ...)
- logical1: First logical value.
- [logical2]: Optional additional logical values.
- ...: Up to 254 arguments in modern Excel.
What it does
XOR performs exclusive-or logic. With two conditions, it returns TRUE when exactly one condition is TRUE. With more inputs, XOR follows parity rules (TRUE if an odd number of inputs are TRUE).
Excel XOR Function Examples
Two-condition exclusive check
=XOR(A2>=85, B2>=90)
TRUE when exactly one threshold is met.
XOR with IF
=IF(XOR(A2="East", B2="VIP"), "Special routing", "Standard")
Branches on exclusive combinations.
logical-checks.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Score | Attendance % | Approved |
| 2 | 92 | 96 | Yes |
| 3 | 78 | 88 | No |
| 4 | 85 | 91 | Yes |
| 5 | 66 | 84 | No |
| 6 | 90 | 93 | Yes |
| 7 | Output |
Input Formula
Need Help?
Tips
- Prefer OR/AND for most business validations unless exclusivity is required.
- Test XOR formulas with both TRUE/FALSE combinations.
- Document parity behavior when more than two inputs are used.
XOR Function Use Cases
- Model mutually exclusive flags
- Detect mismatched boolean pairs
- Parity-style validations across several checks
- Game or routing logic with exclusive states
- Educational demos of logical operators
Common mistakes - XOR function not working
- Expecting OR behavior from XOR
- Using XOR when AND is required
- Forgetting parity behavior with 3+ inputs
- Mixing non-boolean values without comparisons
- Over-complicating rules that IF/IFS could express
FAQ
What does XOR mean in plain English?
XOR is TRUE when an odd number of inputs are TRUE. With two tests, it means exactly one is TRUE.
XOR vs OR?
OR is TRUE if any input is TRUE, including both. XOR is stricter for two-input exclusive cases.
Can XOR take more than two arguments?
Yes. XOR generalizes to parity logic across many tests.
Is XOR common in business spreadsheets?
It is less common than AND/OR, but useful for toggle-like rules and exclusive eligibility.
Can XOR be nested in IF?
Yes, like other logical functions.
Comparison
| Function | Typical meaning (2 inputs) |
|---|---|
| XOR | Exactly one TRUE |
| OR | At least one TRUE |
| AND | Both TRUE |
Example
=XOR(A2>=85, B2>=90)
Advanced examples
XOR as a toggle helper
Combine XOR with running state cells carefully; spreadsheets are not event-driven like code, so document intent for teammates.