Excel BITLSHIFT function

Function              BITLSHIFT

Description        Excel BITLSHIFT function returns a number shifted left by some number of bits.

Syntax                  BITLSHIFT(number, shift_amount)

Number               Required. Must be an integer, greater than or equal to zero.

Shift amount      Required. Shift_amount must be an integer.

Example:

=BITLSHIFT(34,3) = 272

=BITLSHIFT(34,-2) = 8

Usage Notes:

• Shifting a number left is basically adding zeros (0) to the right of the binary form of the number.
• If either argument is outside their constraints, BITLSHIFT returns the #NUM! error value.
• BITLSHIFT returns the #NUM! error value if Number is greater than (2^48)-1.
• BITLSHIFT returns the #NUM! error value when the absolute value of Shift_amount is greater than 53.
• BITLSHIFT returns the #VALUE! error value when input is a non-numeric value.
• A negative number used as the Shift_amount argument shifts the number of bits to the right.
• A negative number used as the Shift_amount argument returns the same result as a positive shift_amount argument for the BITRSHIFT function.