BITXOR functionThe BITXOR function is a bitwise XOR (exclusive or) of 2 numbers that returns a bit of “1” if 2 bits are different, and a bit of “0” otherwise. This function returns a number that’s the result of performing an XOR function at each bit of the 2 given numbers.
Parts of a BITXOR function
The first numeric value.
The second numeric value.
Order doesn’t matter for values. The result is the same regardless.
Values don’t necessarily have to be numbers. Instead, they may be coerced. For example, a string value of “3” can be coerced to be simply 3, and a Boolean value of TRUE can be coerced to 1.
In the following example, we use BITXOR with values inlined into the function. The values 2 (represented as 10 in base 2) and 4 (represented as 100 in base 2) result in 6 (represented as 110 in base 2):
In this example, values of 2 and 4 result in a BITXOR of 6. However, this time we use cell references to use as our values:
BITOR: The BITOR function returns the bitwise Boolean OR of 2 numbers.
XOR: The XOR function returns TRUE if an odd number of the provided arguments are logically true, and FALSE otherwise.