The Excel XOR Function

Exclusive Or

The Exclusive Or logical operation returns True if one (and only one) of two supplied conditions evaluate to True. It can be thought of as "either A or B, but not both A and B".

More generally (i.e. when there is just one condition or when there are more than two conditions), the Exclusive Or operation evaluates to True if an odd number of conditions evaluate to True.

For further information on the Exclusive Or logical operation, see the Wikipedia Exclusive Or Page

Related Function:
Or Function

Basic Description

The Excel Xor function returns the Exclusive Or logical operation for one or more supplied conditions.

I.e. the Xor function returns TRUE if an odd number of the supplied conditions evaluate to TRUE, and FALSE otherwise.

Note: the Xor function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

XOR( logical_test1, [logical_test2], ... )

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 Function Examples

The following spreadsheet shows six examples of the Excel Xor function.

1=XOR( 1>0, 2>0 ) (conditions evaluate to TRUE, TRUE)
2=XOR( 1>0, 0>1 ) (conditions evaluate to TRUE, FALSE)
3=XOR( 0>1, 2>0 ) (conditions evaluate to FALSE, TRUE)
4=XOR( 0>1, 0>2 ) (conditions evaluate to FALSE, FALSE)
5=XOR( 1>0, 2>0, 0>1, 0>2 ) (conditions evaluate to TRUE, TRUE, FALSE, FALSE)
6=XOR( 1>0, 2>0, 3>0, 0>1 ) (conditions evaluate to TRUE, TRUE, TRUE, FALSE)

Further information and examples of the Excel Xor function are provided on the Microsoft Office website.

Xor Function Errors

Common Errors
#VALUE!-Occurs if none of the conditions supplied to the Xor function evaluate to logical values or numeric values.
#NAME?-Occurs if Excel does not recognise the function name. This is probably because you have an earlier version of Excel, which does not support the Xor function.