Shifts a number to the left by the specified number of bits.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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.
=BITLSHIFT(5, 2)결과: 20
Shifting 5 (binary 101) left by 2 positions results in 20 (binary 10100).
If the shift amount is negative, the function will perform a right shift instead.