BITXOR function

Microsoft Office ShapeSheet

BITXOR function

See also

Returns a 16-bit binary number in which each bit is set to 1 if the corresponding bit in either but not both binary number1 and binary number2 is 1. Otherwise, the bit is set to 0.

Syntax

BITXOR(binary number1,binary number2)

Example

BITXOR(12,6)

Returns 10. The 12 = 0...01100. The 6 = 0...00110. Therefore, BITXOR(12,6) = 0...01010.