The BitOr function in Excel returns the bitwise ‘OR’ of two numbers.
Syntax:
=BITOR( number1, number2 )
Parameter:
Example:
The binary equivalent of 5 is 101.
The binary equivalent of 6 is 110.
The digit ‘1’ appears at places 1, 2, and 3 in one or both of the binary digits 101 and 110. (counting from the right).
As a consequence, the bitwise ‘OR’ result is the binary number with a ‘1’ in places 1, 2, and 3. (from the right). That is, the binary number 111.
This value is returned as the integer 7 in decimal form.
Ask Your Query