Returns the value of the specified argument shifted to the left by the specified number of bits.
Syntax
 Copy Code
|
|---|
BITLSHIFT( Integer x, Integer bits ) → Integer |
Parameters
- x
- Required. The number to shift. Must be greater than or equal to zero.
- bits
- Required. The number of bits to shift.
Remarks
Shifting a number to the left is equivalent to adding zeros to the right of the binary representation of the number. For example, shifting the number 3 to the left by two bits, converts the binary value of 3 (11) to 1100, or 12 in decimal.
If any of the arguments violates its constraints, BITLSHIFT returns the #NUM! error value. If the specified values are not integer, they are automatically converted. If bits is negative, the function shifts the specified number to the right instead.
Example
| Formula
Copy Code
|
|---|
=BITLSHIFT(3,2) |
See Also
Function Reference
BITAND Function
BITXOR Function
BITRSHIFT Function