Returns a bitwise 'exclusive OR' of two numbers.
ไวยากรณ์
BITXOR(number1, number2)อาร์กิวเมนต์
number1จำเป็น
The first integer to compare.
number2จำเป็น
The second integer to compare.
The BITXOR function compares the binary representations of two integers and returns a result where each bit is 1 if the corresponding bits of the inputs are different, and 0 if they are the same. It is commonly used for low-level data manipulation and bitwise logic operations.
=BITXOR(5, 3)→6Binary 101 (5) XOR 011 (3) equals 110 (6).
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =BITXOR( followed by your two numbers separated by a comma and close with a parenthesis.
Calculate
Press Enter to see the bitwise XOR result.
BITXOR returns a #NUM! error if the numbers are negative or exceed the maximum allowed value.