Translations:Documentation/Calc Functions/BITLSHIFT/19/en

From The Document Foundation Wiki
Jump to: navigation, search
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