BITLSHIFT

Returns the value of the specified argument shifted to the left by the specified number of bits.

Syntax

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

=BITLSHIFT(3,2)

See Also

Function Reference
BITAND Function
BITXOR Function
BITRSHIFT Function