Shifts a number to the left by the specified number of bits.
この関数は Google スプレッドシートでも 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.