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

Data Analysis

  • Remove Duplicates Example in Excel
  • How to Create Column Chart in Excel
  • Number and Text Filters Examples in Excel
  • How to Create Gantt Chart in Excel
  • How To Perform and Interpret Regression Analysis in Excel

References

  • How to get address of named range in Excel
  • How to use Excel OFFSET function
  • Get nth match with INDEX / MATCH in Excel
  • How to create dynamic named range with OFFSET in Excel
  • Count unique text values with criteria

Data Validations

  • Excel Data validation no punctuation
  • Excel Data validation must not contain
  • Excel Data validation unique values only
  • How To Create Drop-down List in Excel
  • Excel Data validation exists in list

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

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

  • IF with boolean logic in Excel
  • IF with wildcards in Excel
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • OR function Examples in Excel

Date Time

  • Calculate time difference in hours as decimal value in Excel
  • Get project end date in Excel
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Check If Two Dates are same month in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign data to groups in Excel
  • Running count group by n size in Excel

General

  • Excel Default Templates
  • Index and match on multiple columns in Excel
  • Transpose: Switch ‘Rows to Columns’ or ‘Columns to Rows’ in Excel
  • Flash Fill in Excel
  • How to test a range for numbers in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning