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.

How to use 

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.