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
- Click on empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select Engineering category.
5. Select BITXOR function.
6. Then select ok.
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.
Examples of BITXOR function in Excel
Example 1:
How to use BITXOR function in excel
You can see examples of BITXOR function below:
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 1110Purpose 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)
