XOR Function in Excel: Syntax, Examples and Free Practice
XOR is an Excel Logic function. Returns TRUE if an odd number of the given conditions are true.
XOR syntax
Arguments
logical1: The first condition to checklogical2: An additional condition to check (optional) (optional)
When to use XOR
XOR is used to build decision rules directly into a spreadsheet instead of manually judging each row.
Practice XOR online, free
Open the live Excel-style spreadsheet and try XOR yourself. No Excel install or sign-up needed to start.
Practice XOR now →More Logic functions
Frequently asked questions
What does the XOR function do in Excel?
Returns TRUE if an odd number of the given conditions are true.
What is the syntax of XOR in Excel?
The syntax is =XOR(logical1, [logical2], ...). logical1: The first condition to check; logical2: An additional condition to check (optional) (optional).
Where can I practice XOR online for free?
Open the free live spreadsheet on Cellgrids and try XOR yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Logic functions · Excel case studies · Excel tutorials · Excel shortcuts