BITXOR

Returns the bitwise 'XOR' of the specified numbers.

Syntax

BITXOR( Integer x, Integer y ) → Integer

Parameters

x

Required. The first argument of the operation. Must be greater than or equal to zero.

y

Required. The second argument of the operation. Must be greater than or equal to zero.

Remarks

This function calculates the bitwise 'XOR' of its arguments, that is, the value of each bit position is 1 if the values of the parameters at that bit position are not equal; in other words, one of the bits is 0 and the other is 1.

If either argument is less than 0 or greater than or equal to (2^48), BITXOR returns the #NUM! error value. If an argument is not an integer number, the argument is converted automatically.

Example

Formula

=BITXOR(5,4)
=BITXOR(100,11)

See Also

Function Reference