From The Document Foundation Wiki
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
|