Shifts a number to the left by the specified number of bits.
Cú pháp
BITLSHIFT(number, shift_amount)Đối số
numberbắt buộc
The integer to shift.
shift_amountbắt buộc
The number of bits to shift by.
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.
=BITLSHIFT(5, 2)→20Shifting 5 (binary 101) left by 2 positions results in 20 (binary 10100).
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =BITLSHIFT(number, shift_amount) and replace the arguments with your values.
If the shift amount is negative, the function will perform a right shift instead.