EXCEL BITOR FUNCTION

The BitOr function in Excel returns the bitwise ‘OR’ of two numbers.

Syntax:

=BITOR( number1number2 )

Parameter:

  • The number parameters given are all positive integers.

Example:

The binary equivalent of 5 is 101.
The binary equivalent of 6 is 110.
The digit ‘1’ appears at places 1, 2, and 3 in one or both of the binary digits 101 and 110. (counting from the right).
As a consequence, the bitwise ‘OR’ result is the binary number with a ‘1’ in places 1, 2, and 3. (from the right). That is, the binary number 111.
This value is returned as the integer 7 in decimal form.

  • #NUM! – Occurs if one or both of the given number arguments is a non-integer; one or both of the supplied number arguments is negative or larger than (248).
  • #VALUE! – Occurs when one or both of the supplied number arguments are non-numeric.

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now