Returns a bitwise boolean 'XOR' of two numbers.
Sample Usage
BITXOR(1,5)
BITXOR(C5,C6)
Syntax
BITXOR(number1,number2)
- number1 - The first number.
- number2 - The second number.
Examples
BITXOR(1,5) returns a value of 4.
BITXOR(C5,C6) returns the bitwise boolean XOR of the two numbers contained in C5 and C6.
Notes
- In the result, each bit position is 1 if the values of the parameters at that bit position are not equal; in other words, one value is 0 and the other is 1.
- The values returned from the bit positions progress from right to left as powers of 2. The rightmost bit returns 1 (2^0), the bit to its left returns 2 (2^1), and so on.
- If either argument is less than 0, BITXOR returns the #NUM! error value.
- If either argument is greater than (2^48)-1, BITXOR returns the #NUM! error value.
- If either argument is a non-numeric value, BITXOR returns the #VALUE! error value.