Excel BITOR Function

The BITOR function is used to return a decimal representation of the bitwise OR of two numerical values. A logical OR operation is performed for each of the binary representation of the numbers and it results in the return of the number.

The main purpose of the function is to return the Bitwise “OR”of two numbers and the result is a decimal value.

Figure 1: Excel BITOR Function

The syntax of the function

The basic syntax for the function is:

=BITOR (num1, num2)

The arguments of the whole syntax are:

  • Num1 – First positive decimal numeral
  • Num2 – Second positive decimal numeral

use of the function

This function requires that each number argument must be greater than or equal to zero and not larger than 2^48-1.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar