Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • To count total rows in a range in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • How to create dynamic named range with OFFSET in Excel
  • How to get address of last cell in range in Excel
  • How to use Excel ROW Function

Data Analysis Examples

  • How to calculate average last N values in a table in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • How to count table rows in Excel
  • How to create dynamic reference table name in Excel
  • How to count table columns in Excel

Data Validation Examples

  • Data validation must not exist in list
  • How To Create Drop-down List in Excel
  • Excel Data validation allow uppercase only
  • Excel Data validation whole percentage only
  • Excel Data validation no punctuation

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.

Worked Example:   XOR function: Description, Usage, Syntax, Examples and Explanation

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.

Worked Example:   XOR function: Description, Usage, Syntax, Examples and Explanation

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:

Worked Example:   XOR function: Description, Usage, Syntax, Examples and Explanation

 

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:

How to use Excel TRUE Function

Next Post:

44 Practical Excel IF function Examples

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
  • How to check if cell contains one of many things in Excel
  • Manipulating text strings using Left, Mid, Right, Len, Substitute in Excel
  • How to find and replace multiple values at same time in Excel
  • NUMBERVALUE function: Description, Usage, Syntax, Examples and Explanation
  • How to count line breaks in cell in Excel worksheet
  • Roll back weekday to Friday base on a particular date in Excel
  • Display Date is workday in Excel
  • Calculate days remaining in Excel
  • Count birthdays by month in Excel
  • Convert time to time zone in Excel
  • AMORLINC function: Description, Usage, Syntax, Examples and Explanation
  • COUPNUM function: Description, Usage, Syntax, Examples and Explanation
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARDE function: Description, Usage, Syntax, Examples and Explanation
  • DDB function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles