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.