Bitwise OR Function in Excel 2013

This is the new function introduced in Excel 2013. This function is used to find out the Bitwise OR of two numbers represented in binary form. In this firstly 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 1 or anyone of the digit is 1 then answer will be 1 otherwise 0, then second digit of the first binary number and second digit of the second binary number is compared and the process is continued till all the digits are compared and the it will give the output in the form of decimal number.

Lets have a look on the following steps:

Step 1

First go to Excel 2013.

Step 2

Now select the Blank workbook templates from the available templates.

bitwiseor-in-excel2013.jpg

Step 3

Now write the following numbers like this.

bitwiseor-function-in-excel2013.jpg

Step 4
 
 If we want to find out the Bitwise OR of two decimal numbers then we will write the following formula.

Excel2013-bitwiseor-function.jpg

Step 5
 
The output will be like this.

Excel2013-bitwiseor-function1.jpg

Up Next
    Ebook Download
    View all
    Learn
    View all