BITXOR

  • Updated

Returns a bitwise boolean 'XOR' of two numbers.

Sample Usage

BITXOR(1,5)
BITXOR(C5,C6)

Syntax

BITXOR(number1,number2)

  • number1 - The first number.
  • number2 - The second number.

Examples

BITXOR(1,5) returns a value of 4.
BITXOR(C5,C6) returns the bitwise boolean XOR of the two numbers contained in C5 and C6.

Notes

  • In the result, each bit position is 1 if the values of the parameters at that bit position are not equal; in other words, one value is 0 and the other is 1. 
  • The values returned from the bit positions progress from right to left as powers of 2. The rightmost bit returns 1 (2^0), the bit to its left returns 2 (2^1), and so on.
  • If either argument is less than 0, BITXOR returns the #NUM! error value.
  • If either argument is greater than (2^48)-1, BITXOR returns the #NUM! error value.
  • If either argument is a non-numeric value, BITXOR returns the #VALUE! error value.