Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to create dynamic reference table name in Excel
  • Chart Axes in Excel
  • Number and Text Filters Examples in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • How To Insert and Customize Sparklines in Excel

References

  • Lookup entire row in Excel
  • How to get last row in text data in Excel
  • Complete List of Excel Lookup and Reference Functions, References and Examples
  • Basic INDEX MATCH approximate in Excel
  • How to use Excel ROWS Function

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation specific characters only
  • Excel Data validation number multiple 100
  • Prevent invalid data entering in specific cells
  • How To Create Drop-down List in Excel

How to use Excel XOR Function

by

This Excel tutorial explains how to use the XOR function with syntax and examples.

Excel XOR Function Function Description

Excel XOR function performs what is called “exclusive OR”.

The XOR function returns the Exclusive Or logical operation for one or more supplied conditions. With two logical statements, XOR returns TRUE if either statement is TRUE, but returns FALSE if both statements are TRUE. If neither is TRUE, XOR also returns FALSE.

XOR Function Examples

Explanation: 

Base on the example above,  the XOR function returns TRUE if an odd number of the supplied conditions evaluate to TRUE, and FALSE otherwise.

Syntax

The syntax of the function is:

XOR( logical_test1, [logical_test2], … )

Arguments

where the logical_test arguments are between 1 and 254 supplied conditions that evaluate to either TRUE or FALSE.

Note that:

  • If the logical_test arguments evaluate to numbers, instead of logical values, the value zero is treated as FALSE and all non-zero values are treated as TRUE
  • XOR was introduced in Excel 2013.

Return

TRUE or FALSE

With more than 2 logicals

With more than 2 logicals, XOR only returns TRUE when the number of TRUE logicals is odd, as shown in the following example:

 

Notes:

  • Logical arguments must evaluate to TRUE or FALSE, 1 or 0, or be references that contain logical values.
  • Empty references are ignored.
  • XOR returns #VALUE! if no logical values are found.
  • With more than two logicals, XOR returns TRUE when the number of TRUE logicals is odd, and FALSE if not.

Post navigation

Previous Post:

VLOOKUP without #N/A error in Excel

Next Post:

Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel XOR Function
  • How to use Excel NOT Function
  • Not Equal To ‘<>‘ operator in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Add workdays to date custom weekends in Excel
  • How to get Weekdays, Working days between Two Dates in Excel
  • Assign points based on late time in Excel
  • Calculate time difference in hours as decimal value in Excel
  • Add decimal hours to time in Excel

Grouping

  • Group numbers at uneven intervals in Excel
  • Calculate conditional mode with criteria in Excel
  • If cell contains one of many things in Excel
  • Group times into unequal buckets in Excel
  • How to randomly assign data to groups in Excel

General

  • Check if multiple cells have same value with case sensitive in Excel
  • Count cells that contain errors in Excel
  • AutoRecover file that was never saved in Excel
  • How to generate random number between two numbers in Excel
  • How to Create Calendar in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning