How it works.
XOR tests conditions and returns TRUE if exactly one (or an odd number) of arguments evaluates to TRUE, and FALSE if both or neither are TRUE.
Formula syntax.
Standard Excel Notation=XOR(logical1, [logical2], ...)[like_this] are optional; all other arguments are required.Formula arguments.
Every parameter accepted by the XOR function is detailed below.
First condition to test.
Example value:A2>50Second condition to test.
Example value:B2>50Simple example.
Step-by-Step ScenarioBenefit Plan - Exclusive Option Check
Verify that an employee selected exactly one pension tier.
| Employee | Plan A | Plan B | Valid Election? |
|---|---|---|---|
| Alice | Yes | No | — |
| Bob | Yes | Yes | — |
| Charlie | No | No | — |
=XOR(B2="Yes", C2="Yes")Evaluates XOR over the sample table cells, placing the verified output in cell D2.
Formula generator.
Full Generator WizardCustomize the argument fields below to generate a tailored XOR formula ready to paste directly into your worksheet.
=XOR()Expected result behavior.
Returns boolean TRUE based on sample evaluation criteria and active cell references.
Best Practices
- Ideal for bonus eligibility rules where a rep qualifies for Option A OR Option B, but not both.
Common Mistakes
- Unlike standard OR, XOR returns FALSE if BOTH conditions are TRUE.
Platform & version compatibility.
Verified platform compatibility matrix based on actual spreadsheet calculation engine specifications.
Core standard function supported across all modern and legacy Microsoft Excel versions (365, 2021, 2019, 2016, 2013, 2010), as well as Excel for the Web and Mac.
100% compatible with Google Sheets. Uses identical argument order, data types, and standard calculation logic.
Frequently asked questions.
Technical Q&ACan I use XOR across different worksheets in Excel?↓
Yes. You can reference cells located on other sheets by including the sheet name followed by an exclamation mark, for example: =XOR(Sheet2!A2:A10). If the sheet name contains spaces, enclose it in single quotes: ='Q1 Report'!A2:A10.
What is the most common reason for errors in XOR?↓
Unlike standard OR, XOR returns FALSE if BOTH conditions are TRUE.
Does XOR work identically in Google Sheets?↓
Yes, XOR is supported in both Microsoft Excel and Google Sheets with standard evaluation behavior.