# Documentation/Calc Functions/BITOR

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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.

## 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 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

BITOR