Documentation/Calc Functions/BITOR

From The Document Foundation Wiki
Jump to: navigation, search
Other languages:
English

Function name:

BITOR

Category:

Mathematical

Summary:

Returns a bitwise logical "or" of the parameters. If any one of the values or both the values at a given position is/are 1 in the binary representation of the parameter numbers then the output is 1 at that position.

Im-jabber.svg

Note:
This functions is available since LibreOfficeDev 3.5.

Syntax:

BITOR(Number 1; Number 2)

Returns:

Returns a positive integer.

Arguments:

Number 1 and Number 2 are positive integers less than 2 ^ 48 (281,474,976,710,656).

  • If either argument is a decimal number then its floor value is considered.
  • If either argument is less than 0, BITOR returns the Err:502.
  • If either argument is a non-integer or is greater than (2^48)-1, BITOR returns the Err:502.

Additional details:

None

Examples:

Formula Description Returns
=BITOR(6;10) 6 in binary is 0110 and 10 in binary is 1010 so
(0110 | 1010 = 1110)
14 (1110 or E)
=BITOR(6.123;10) floor value of 6.123 is taken so 6 in binary is 0110 and 10 in binary is 1010 so
(0110 | 1010 = 1110)
14 (1110 or E)
=BITOR(123;156) 123 in binary is 01111011 and 156 in binary is 10011100 so
(01111011 | 10011100 = 11111111)
255 (11111111)
=BITOR(123; 2^48 + 5) number 2 argument is greater than 2^48 hence it will return an error Err:502
=BITOR(123; -5) number 2 argument is negative hence it will return an error Err:502
BITOR example showing that if either number have 1 at a position then the function returns 1 at that position.

Related LibreOffice functions:

OR

BITAND

BITXOR

ODF standard:

Section 6.6.4, part 2

Equivalent Excel functions:

BITOR