Google Sheets Function

BITLSHIFT

Shifts a number to the left by the specified number of bits.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

BITLSHIFT(number, shift_amount)

The BITLSHIFT function returns a number shifted left by a specified number of bits. Shifting a number left is equivalent to multiplying it by 2 raised to the power of the shift amount.

Arguments

numberrequiredThe integer to shift.
shift_amountrequiredThe number of bits to shift by.

Examples

=BITLSHIFT(5, 2)

Result: 20

Shifting 5 (binary 101) left by 2 positions results in 20 (binary 10100).

FAQ

What happens if shift_amount is negative?

If the shift amount is negative, the function will perform a right shift instead.

Related functions

BITRSHIFT BITAND BITOR BITXOR