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)
  • number1 - A positive decimal number.
  • number2 - A positive decimal number.

Using the BITOR function

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

Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Related functions

Excel BITAND Function

BITAND Function

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

OR Function

The Excel OR function is a logical function used to test multiple conditions at the same time. OR returns TRUE if any condition is TRUE. If all conditions are FALSE, the OR function returns FALSE. The OR function is often used with the IF function and can be combined with NOT and AND to create …

Related functions

Links