From The Document Foundation Wiki
Formula |
Description |
Returns
|
=BITLSHIFT(6;3) |
6 in binary is 0110 which when applied with left shift by 3-bit gives 0110000 or (0110 << 3 = 0110000) |
48 (0110000)
|
=BITLSHIFT(6;-1) |
6 in binary is 0110 which when applied with left shift by -1-bit gives 0011 which is equivalent to right shift by 1-bit or (0110 << -1 = 0011) |
3 (0011)
|
=BITLSHIFT(6.123;3) |
floor of 6.123 is taken so 6 in binary is 0110 which when applied with left shift by 3-bit gives 0110000 or (0110 << 3 = 0110000) |
48 (0110000)
|
=BITLSHIFT(6;3.6) |
6 in binary is 0110 which when applied with left shift by 3-bit(floor of 3.6 is considered) gives 0110000 or (0110 << 3 = 0110000) |
48 (0110000)
|
=BITLSHIFT(-6;3) |
Number is negative so function returns error value |
Err:502
|