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

Arguments

number1 - A positive decimal number.
number2 - A positive decimal number.

Syntax

=BITOR(number1, number2)

Usage notes

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

Author

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.