Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts.

# BITXOR function

This article describes the formula syntax and usage of the **BIT****XOR** function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.

## Description

Returns a bitwise 'XOR' of two numbers.

## Syntax

BITXOR(number1, number2)

The BITXOR function syntax has the following arguments.

**Number1**Required. Must be greater than or equal to 0.**Number2**Required. Must be greater than or equal to 0.

## Remarks

- BITXOR returns a decimal number that is the result of the sum of a bitwise 'XOR' (exclusive XOR) of its parameters.
- If either argument is outside its constraint, 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.
- 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. For example, using BITXOR(5,3), 5 is expressed as 101 in binary and 3 as 11 in binary. To help with comparison, you can consider 3 as 011. From right to left, the bit values at the three positions in this example are the same (1) only at the rightmost position. A 'not equal' result returns a 1 for the second and third positions from the right, and an ‘equal’ result returns 0 for the rightmost position.
- Values of 1 returned from the bit positions progress from right to left as powers of 2. The rightmost bit returns 1 (2^0), the bit to the left returns 2 (2^1), and so on.
- Using the same example, 0 is returned for the rightmost bit position because it is a 0, 2 (2^1) is returned for the second bit position from the right (a 1 value), and 4 (2^2) is returned for the leftmost bit (also a 1 value). The total is 6, in decimal representation.

## Example

The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works.

To work more in-depth with the example data in Excel, download the embedded workbook to your computer, and then open it in Excel.

Applies to:

Excel 2013, Excel Online