Manuals/calci/BITLSHIFT
Jump to navigation
Jump to search
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
- =BITLSHIFT(8,2) = 32
- =BITLSHIFT(14,3) = 112
- =BITLSHIFT(-3,1) = -6
- =BITLSHIFT(17,-2) = 1073741824
Related Videos
See Also
References