BITLSHIFT function

The BITLSHIFT function shifts the bits of the input a certain number of places to the left. Bits on the right are filled with zeroes (0s).

Parts of a BITLSHIFT function

BITLSHIFT(value,shift_amount)

Part Description Notes
value The number to be shifted. Must be a non-negative number.
shift_amount The number of places to shift. Must be a value between -53 and 53, inclusive. Supplying a negative value will effectively be a BITRSHIFT.

Sample formulas

BITLSHIFT(9, 2)
BITLSHIFT(A2, 4)

Notes

  • Values don't necessarily have to be numbers. 
  • Values may be coerced. For example, a string value of “3” can be coerced to be simply 3 and a boolean value of TRUE can be coerced to 1.

Examples

In this example, we use BITLSHIFT with values inlined into the function. The value 2 (represented as 10 in base 2) has its bits shifted left by the shift_amount of 2, resulting in 8 (represented as 1000 in base 2).

  A B
1 Formula Result
2 =BITLSHIFT(2,2) 8


Similar to the last example, a value of 2 being shifted by 2 results in a BITLSHIFT of 8. However, in this example, we use cell references to grab our values.

  A B C
1 Formula Result Reference cells
2 =BITLSHIFT(C2,C3) 8 2

Related functions

BITRSHIFT: The BITRSHIFT function shifts the bits of the input a certain number of places to the right. Bits on the left are filled with zeroes (0s).

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false