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:


Step 3

Now write the following numbers like this:


Step 4

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


Step 5

The output will be like this: