Engineering - BITOR Function

Description

The BITOR function returns a bitwise 'OR' of two numbers.

Syntax

BITOR (number1, number2)

Arguments

Argument Description Required/ Optional
Number1 Must be in decimal form and greater than or equal to 0. Required
Number2 Must be in decimal form and greater than or equal to 0. Required

Notes

  • The result is a bitwise 'OR' of its parameters.

  • In the result, each bit position is 1 if any of the parameter's bits at that position are 1

  • The values returned from the bit positions progress from right to left as powers of 2. The rightmost bit returns 1 (2^0), the bit to the left returns 2 (2^1), and so on

  • If either argument is outside their constraints, BITOR returns the #NUM! error value

  • If either argument is greater than (2^48)-1, BITOR returns the #NUM! error value

  • If either argument is a non-numeric value, BITOR returns the #VALUE! error value

Applicability

Excel 2013, Excel 2016

Example

BITOR Function
advanced_excel_engineering_functions.htm
Advertisements