From The Document Foundation Wiki
Formula |
Description |
Returns
|
=BITXOR(6;10) |
6 in binary is 0110 and 10 in binary is 1010 so (0110 ^ 1010 = 1100) |
12 (1100)
|
=BITXOR(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 = 1100) |
12 (1100)
|
=BITOR(123;156) |
123 in binary is 01111011 and 156 in binary is 10011100 so (0110 ^ 1010 = 11100111) |
231 (11100111)
|
=BITXOR(123; 2^48 + 5) |
number 2 argument is greater than 2^48 hence it will return an error |
Err:502
|
=BITXOR(123; -5) |
number 2 argument is negative hence it will return an error |
Err:502
|