Excel BITXOR Function

Using the Excel BITXOR Function

Excel BITXOR Function

Summary

The Excel BITXOR function returns a bitwise XOR of two numbers. A logical XOR operation is performed for each corresponding bit in the binary representation of a number and the result is returned.

Syntax

=BITXOR (number1, number2)

Syntax Breakdown

Number 1
Required. Any number greater than or equal to zero. Must not be larger than 2^48 - 1.

Number 2
Required. Any number greater than or equal to zero. Must not be larger than 2^48 - 1.

Usage Notes

BITXOR returns a decimal number that is the result of the sum of a bitwise XOR of its parameters.

BITXOR Errors
The function returns the following errors:

1) #NUM! if either argument is outside its constraints

2) #NUM! if either argument is greater than 2^48 - 1

3) #VALUE! if either argument is non-numeric