Exceljet

Quick, clean, and to the point

Excel BITOR Function

Excel BITOR function
Summary 
The Excel BITOR function returns a decimal number representing the bitwise OR of two numbers. For each corresponding bit in the binary representation of the numbers a logical OR operation is performed, and the resulting number returned.
Purpose 
Returns a 'Bitwise Or' of two numbers
Return value 
Decimal Number
Syntax 
=BITOR (number1, number2)
Arguments 
  • number1 - A positive decimal number.
  • number2 - A positive decimal number.
Usage notes 

The input numbers must be greater than or equal to zero and no larger than 2^48 - 1.

Related functions 
Excel BITAND function
Excel BITAND Function
The Excel BITAND function returns a decimal number representing the bitwise AND of two numbers.
Excel OR function
Excel OR Function

The OR function is a logical function to test multiple conditions at the same time. OR returns either TRUE or FALSE. For example, to test A1 for either "x" or "y", use =OR(A1="x",A1="y"). The OR function can be used as the logical test inside the...

500 Formula Examples, thoughtfully explained.