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

    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