BITXOR
Returns a bitwise 'Exclusive Or' of two numbers.
EngineeringEngineering & Science
What it does
Performs a bitwise XOR. The result has bits set to 1 only if exactly one of the corresponding bits in the inputs is 1.
Syntax
BITXOR(number1, number2)
Arguments
number1(number) — First integer.number2(number) — Second integer.
Examples
Bitwise XOR
XOR 5 (101) and 3 (011).
FORMULA
=BITXOR(5, 3)
RESULT
6
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Val1 | Val2 |
| 2 | 5 | 3 |