Author: Oscar Cronquist Article last updated on March 28, 2018

The BITLSHIFT function calculates a number whose binary representation is shifted left by a specified number of bits.

Formula in cell D3:


Number 5 is 101 binary. Adding one zero from the right you get 1010 binary which is number 10.

Excel Function Syntax



number Required. The number you want to shift.
shift_amount Required. How many zeros you want to add from the right.


Maximum number is 2^48 = 2.81475E+14.