From The Document Foundation Wiki
Formula |
Description |
Returns
|
=BITRSHIFT(15;3) |
15 in binary is 1111 which when applied with right shift by 3-bit gives 0001 or (1111 >> 3 = 0001) |
1 (0001)
|
=BITRSHIFT(6;-1) |
6 in binary is 0110 which when applied with right shift by -1-bit gives 1100 which is equivalent to left shift by 1-bit or (0110 >> -1 = 1100) |
12 (1100)
|
=BITRSHIFT(15.123;3) |
floor of 15.123 is taken so 15 in binary is 1111 which when applied with right shift by 3-bit gives 0001 or (1111 >> 3 = 0001) |
1 (0001)
|
=BITRSHIFT(15;3.7) |
15 in binary is 1111 which when applied with right shift by 3-bit(floor of 3.7 is considered) gives 0001 or (1111 >> 3 = 0001) |
1 (0001)
|
=BITRSHIFT(-15;3) |
Number is negative so function returns error value |
Err:502
|