Bitwise And Function in Excel 2013

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

Lets 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, as in:

bitwiseAnd-in-Excel2013.jpg

Step 3

Now write the following numbers like this:

bitwiseAnd-function-in-Excel2013.jpg

Step 4

If we want to determine the bitwise And of two decimal numbers then we will write the following formula:

Excel2013-BitwiseAnd-function.jpg

Step 5

The output will be like this:

Excel2013-bitwiseAnd-function1.jpg


Similar Articles