How to use the BITXOR function
The BITXOR function calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers.
XOR is an abbreviation for "Exclusive OR" meaning if both digits at each position are not equal, 1 is returned for that position. If it is equal 0 (zero) is returned.
Formula in cell D3:
5 is 00000101 binary and 9 is 00001001. See picture below on how to do a bitwise "XOR".
Excel Function Syntax
BITXOR(number1, number2)
Arguments
| number1 | Required. A number greater than 0 (zero). |
| number2 | Required. A number greater than 0 (zero). |
Comments
The maximum number you can use is 2^48 = 2.81475E+14.
The BITXOR function returns:
- #NUM! error value if an argument is outside its boundary.
- #NUM! error value if an argument is greater than 2^48 = 2.81475E+14.
- #VALUE! error value if an argument is a non-numeric value.
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Functions in 'Engineering'
The BITXOR function function is one of many functions in the 'Engineering' category.
How to use the BIN2DEC function
The BIN2DEC function converts a binary number to decimal. Formula in cell B3: =BIN2DEC(11001) Excel Function Syntax BIN2DEC(number) Arguments number […]
How to use the BIN2HEX function
The BIN2HEX function converts a binary number to hexadecimal. Formula in cell B3: =BIN2HEX(11001) Excel Function Syntax BIN2HEX(number,[places]) Arguments number […]
How to use the BIN2OCT function
The BIN2OCT function converts a binary number to octal. Formula in cell B3: =BIN2OCT(11001) Excel Function Syntax BIN2OCT(number,[places]) Arguments number […]
How to use the BITAND function
The BITAND function calculates a bitwise 'AND' of two numbers. The function performs AND logic bit by bit on the numbers […]
How to use the BITLSHIFT function
The BITLSHIFT function calculates a number whose binary representation is shifted left by a specified number of bits. Formula in […]
The BITOR function performs a bitwise 'OR' of two numbers. Bitwise meaning each digit in the binary equivalent. Formula in […]
How to use the BITRSHIFT function
The BITRSHIFT function calculates the number where the binary equivalent is shifted right by a specified number of bits and […]
How to use the BITXOR function
The BITXOR function calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers. XOR […]
How to use the COMPLEX function
The COMPLEX function returns a complex number based on a real and imaginary number. Formula in cell B3: =COMPLEX(2,3) Excel […]
How to use the CONVERT function
The CONVERT function converts a number from one measurement system to another. Formula in cell E3: =CONVERT(B3, C3, D3) The […]
How to use the DEC2BIN function
The DEC2BIN function converts a decimal number to a binary number. Formula in cell D3: =DEC2BIN(B3,C3) Excel Function Syntax DEC2BIN(number, […]
How to use the DEC2HEX function
The DEC2HEX function converts a decimal number to a hexadecimal number. Formula in cell D3: =DEC2HEX(B3,C3) Excel Function Syntax DEC2HEX(number, […]
How to use the DEC2OCT function
The DEC2OCT function converts a decimal number to an octal number. Formula in cell D3: =DEC2OCT(B3,C3) Excel Function Syntax DEC2OCT(number, […]
The DELTA function evaluates whether two numerical values are equal. This function is also known as the Kronecker Delta function, read […]
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form