BITXOR Function
Basic Description
The Excel BitXor function returns the bitwise ‘XOR’ (exclusive ‘OR’) for two supplied integers. Note: the BitXor function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.
Syntax: BITXOR( number1, number2 )
where the supplied number arguments are positive integers.
BitXor Function Example 1
Formula:

Result:

In the above example:
DecimalBinary Conversion
If you want to work through the stages of a bitwise ‘XOR’ operation you can use the Excel DEC2BIN and BIN2DEC functions to convert between decimal and binary forms.
 The binary form of 5 is 101.
 The binary form of 6 is 110.
 One (and only one) of the binary numbers 101 and 110 has the digit ‘1’ at position 1 (counting from the right). Therefore, within the result, the rightmost digit is a 1.
 One (and only one) of the binary numbers 101 and 110 has the digit ‘1’ at position 2 (counting from the right). Therefore, within the result, the digit second from the right is a 1.
 Both of the binary numbers 101 and 110 have the digit ‘1’ at position 3 (counting from the right). Therefore, within the result, the third digit from the right is a 0.
 The bitwise ‘XOR’ result is therefore the binary number 011.
 This number is returned in decimal form, as the number 3.
BitXor Function Example 2
Formula:

Result:

In the above example:
 The binary form of 9 is 1001.
 The binary form of 12 is 1100.
 One (and only one) of the binary numbers 101 and 110 has the digit ‘1’ at position 1 (counting from the right). Therefore the rightmost digit of the result is a 1.
 Neither of the binary numbers 101 and 110 have the digit ‘1’ at position 2 (counting from the right). Therefore, within the result, the digit second from the right is a 0.
 One (and only one) of the binary numbers 101 and 110 have the digit ‘1’ at position 3 (counting from the right). Therefore, within the result, the third digit from the right is a 1.
 Bothc of the binary numbers 101 and 110 have the digit ‘1’ at position 4 (counting from the right). Therefore, within the result, the fourth digit from the right is a 0.
 The bitwise ‘XOR’ result is therefore the binary number 0101.
 This number is returned in decimal form, as the number 5.
BitXor Function Errors
#NUM!  – 
Occurs if either:


#VALUE!  –  one or both of the supplied number arguments is nonnumeric. 