# BITLSHIFT Function in Excel – Bit left shift Operation in Excel

BITLSHIFT Function in Excel returns the left shift of supplied integers by specified number of bits.

Note: BITLSHIFT Function was only introduced from Excel 2013 onwards

#### Bit left shift Explained

Bit left shift operator shifts all bits towards left by certain number of specified bits. Let’s see an example of left shift of 212

212 = 11010100 (In binary)

Left shift by 1 bit gives
212<<1 = 110101000

Left shift by 4 bits gives
212<<4 = 110101000000

Left shift by 0 gives
212<<0 =11010100

#### Syntax of BITLSHIFT Function in Excel (BIT LEFT SHIFT OPERATION IN EXCEL):

BITLSHIFT (number, shift_amount)

Where

• number – The Number that you want to perform left shift operation on
• shift_amount – An integer that specifies the number of bits to be shifted left

#### FORMULA: #### RESULT: NOTE: #NUM!   – Error occurs if

• The supplied number arguments is a non-integer;
• The supplied number arguments is negative or is greater than (2^48)-1.