Manuals/calci/BITLSHIFT

Revision as of 06:46, 5 May 2017 by Swapna (talk | contribs) (Created page with "<div style="font-size:30px">'''BITLSHIFT(a,b)'''</div><br/> *where <math>a</math> is the number to be shifted left *<math>b</math> is number of bits to be shifted == Descri...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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