ARTICLE

BITXOR Function in Excel 2013

Posted by Megha Goyal Articles | Office 2013 September 12, 2012
In this article we will discuss how to use the Bitwise Exclusive OR function in Excel 2013.
Reader Level:

This is a new function introduced in Excel 2013. It is in the Engineering category. This function is used to determine the Bitwise Exclusive OR of two numbers represented in binary form. In this first the decimal number is converted to the binary number, then the two binary numbers are compared as the first digit of the first binary number and the first digit of the second binary number is compared if both the digits are the same then the answer will be 0 otherwise 1 then the second digit of the first binary number and the second digit of the second binary number is compared and the process is continued until all the digits are compared and then it will give the output as a decimal number.

Let's have a look at the following steps.

Step 1

First go to Excel 2013.

Step 2

Now select the Blank workbook templates from the available templates.

BitXOR-function-in-Excel2013.jpg

Step 3

Now write the following numbers like this.

bitwiseexclusiveor-function-in-excel2013.jpg

Step 4

If we want to determine the bitwise Exclusive OR of two decimal numbers then we will write the following formula;

Excel2013-bitXOR-function.jpg

Step 5

The output will be like this:

 Use-of-bitXOR-function-in-excel2013.jpg

COMMENT USING

Trending up