Manuals/calci/BITLSHIFT

BITLSHIFT(a,b)


  • where is the number to be shifted left
  • is number of bits to be shifted


Description

  • BITLSHIFT() returns a number shifted to the left, by number of digits specified in the argument.
  •   should be an integer greater than or equal to 0.
  •   must be an integer value.
  • Shifting a number left is equivalent to adding zeros (0) to the right of the binary representation of the number.

For example, a 1-bit shift to the left on the decimal value 4 converts its binary value (100) to 1000, or 8 in decimal.

  • If either argument is a non-numeric value, BITLSHIFT returns the #VALUE! error value.


Examples

  1. =BITLSHIFT(8,2) = 32
  2. =BITLSHIFT(14,3) = 112
  3. =BITLSHIFT(-3,1) = -6
  4. =BITLSHIFT(17,-2) = 1073741824


Related Videos

BITSHIFT OPERATORS


See Also


References