Excel FunctionsLesson 121Free preview
XOR
This lesson is part of Excel · All levels
Summary
XOR (exclusive OR) is an Excel logic function that returns TRUE if the number of correct value conditions is odd. Unlike the OR that only needs one condition correct, the XOR excludes cases when all conditions are correct at once.
Key points
- XOR is true if the number of conditions is odd
- XOR is wrong if the number of conditions is even (including zero)
- Accepting many logical arguments like OR
- Useful for double-option or paired status scenarios
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.