Learn How to Use Microsoft Excel XOR Function

The Microsoft Excel XOR Function

The Microsoft Excel XOR function is used to perform the exclusive OR function. So, it means the XOR function performs that is known as "exclusive OR." It is used with two logical statements; the XOR function returns TRUE if any one of them is TRUE and returns FALSE if both the statements are true. If both the statements are FALSE, the XOR function returns FALSE.

XOR Function Return Value

TRUE or FALSE

XOR Function Syntax

=XOR(logical1,[logical2],...)

Where:

• logical1: It can be an expression, constant, or reference that evaluates TRUE or FALSE.
• logical2: This is optional, and it can also be an expression, constant, and statement that will determine TRUE or FALSE.

How to Use Microsoft Excel XOR Function?

The operation performed by the XOR function is known as "exclusive OR," which is the opposite of "inclusive OR" performed by the OR function. The OR returns TRUE if any of the logic is TRUE, while the XOR function returns TRUE in specific cases.

In the simplest example using the two statements, the XOR will return TRUE if any one of the logical is TRUE, and not when both the logical is TRUE. Basically, the exclusive OR is more used in programming. In simple terms, when you say, "I am planning to visit Shimla or Goa this summer," that means no one is stopping you from visiting both, but you are only planning for the one. 

XOR Function With More than Two Logical

When we use more than two logical, the XOR function will return TRUE only when the number of TRUE logical is odd, as we have shown in the examples below:

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel