Author: Oscar Cronquist Article last updated on October 02, 2018

The XOR function was introduced in Excel 2013 and calculates the logical exclusive OR meaning if at least one of the arguments evaluates to TRUE then the XOR returns TRUE. All arguments must be evaluated to FALSE for the XOR function to return FALSE.

Formula in cell D3:

=XOR(B3,C3)

Excel Function Syntax

XOR(logical1, [logical2],…)

Arguments

logical1 Required. A condition that evaluates to either TRUE or FALSE or their numerical equivalents 1 or 0 (zero). An argument may also be a reference or array.
[logical2] Optional. Up to 253 additional conditions.

Comments

The XOR function returns #VALUE! error value if no logical values can be found in the arguments.

The XOR function ignores empty and text values, 0 (zero) is evaluated to FALSE and any other value is evaluated to TRUE.