Formulas > =BITLSHIFT()
How to Use BITLSHIFT() in Google Sheets
Description
How To Actually Use BITLSHIFT() in Sheets
BITLSHIFT(value, shift_amount)
Try BITLSHIFT yourself
In cells A1:A10, enter integer values. In cells B1:B10, use the BITLSHIFT formula to shift the bits of the corresponding values in column A to the left by 2 places.
Hints (2)
-
Remember that BITLSHIFT takes two arguments: the value and the number of places to shift.
-
Make sure to apply the formula down the column for all rows in B.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the BITLSHIFT() formula:
Generate a BITLSHIFT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses BITLSHIFT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a BITLSHIFT() formula