Excel BITXOR Function

What is BITXOR Function in Excel?


The BITXOR function is one of the Engineering functions of Excel.

It Returns a bitwise ‘Exclusive or’ of two numbers.

We can find this function in Engineering of insert function Tab.

How to use BITXOR function in excel

  1. Click on empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

 fx icon in excel

3. In the insert function tab you will see all functions.

 insert function tab in excel

4. Select Engineering category.

5. Select BITXOR function.

6. Then select ok.

excel BITXOR function

7. In the function arguments Tab you will see BITXOR function.

8. Number1 is the decimal representation of the binary number you want to evaluate.

9. Number2 is the decimal representation of the binary number you want to evaluate.

10. You will see the results in formula result section.

How to use BITXOR function in excel

Examples of BITXOR function in Excel

Example 1:

How to use BITXOR function in excel

You can see examples of BITXOR function below:

Examples of BITXOR function in Excel
bitxor(A2,B2) ----->>>>answer is  0

bitxor(A3,B3) ----->>>>answer is  1

bitxor(A4,B4) ----->>>>answer is  10

bitxor(A5,B5) ----->>>>answer is  11

bitxor(A6,B6) ----->>>>answer is  1111

bitxor(A7,B7) ----->>>>answer is  1110

Purpose of BITXOR function

It Returns a bitwise ‘Exclusive or’ of two numbers.

Return value of BITXOR function

It returns a number.

Arguments of BITXOR function

This function has just 2 Argument.

The argument of BITXOR function is number.

Number1 is the decimal representation of the binary number you want to evaluate.

Number2 is the decimal representation of the binary number you want to evaluate.

The argument of BITXOR function is required and not optional.

BITXOR(number) = number

Version of excel supports BITXOR function

This function is available for all excel versions (2003-2019)

Errors in BITXOR function

BITXOR related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *