What is the syntax for BITXOR in Excel?

The syntax for BITXOR is: =BITXOR(number1, number2)

What are common errors with BITXOR?

#NUM! if numbers negative or > 2^48-1

How do I use the BITXOR function?

To use BITXOR, type =BITXOR( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

Why is BITXOR not working in my Excel?

Common issues with BITXOR include #NUM! if numbers negative or > 2^48-1. Start by checking the syntax =BITXOR(number1, number2), then verify each referenced cell or range.

Engineering

BITXOR Function in Excel

Returns a bitwise XOR of two numbers.

Syntax

=BITXOR(number1, number2)

Arguments

number1 (required): First number
number2 (required): Second number

Examples

=BITXOR(5, 3) - Bitwise XOR of 5 and 3 - Result: 6

BITXOR in technical sheets

Document units in adjacent cells — many engineering functions require exact unit strings.
Use [CONVERT](/functions/convert/) for unit changes before specialized formulas.
Validate inputs with [ISNUMBER](/functions/isnumber/) and range checks.

Common errors

#NUM! if numbers negative or > 2^48-1

Use cases

Bit manipulation
Encryption
Toggle flags

Frequently asked questions

What is the BITXOR function in Excel? BITXOR returns a bitwise XOR of two numbers. The syntax is =BITXOR(number1, number2). Typical use cases include bit manipulation, encryption, toggle flags.
How do I use the BITXOR function? To use BITXOR, type =BITXOR( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
Why is BITXOR not working in my Excel? Common issues with BITXOR include #NUM! if numbers negative or > 2^48-1. Start by checking the syntax =BITXOR(number1, number2), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.