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:
Excel Function Syntax
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.
Optional. Up to 253 additional conditions.
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.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Logical'
The XOR function function is one of many functions in the 'Logical' category.