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