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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle a} is the number to be shifted left
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle b} is number of bits to be shifted


Description

  • BITLSHIFT() returns a number shifted to the left, by number of digits specified in the argument.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle a} should be an integer greater than or equal to 0.
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle b} 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