BITXOR function

The 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

BITXOR(value1, value2)

Part Description Notes
value1 The first numeric value.  
value2 The second numeric value.  

 

Sample formulas

BITXOR(9, 5)

BITXOR(A1, A2)

Notes

  • 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.

Examples

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):

  A B
1 Formula Result
2 =BITXOR(2, 4) 6

 

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:

  A B C
1 Formula Result Reference cells
2 =BITXOR(2, 4) 6 2
3     4

Related functions

  • 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.
Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false