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

 

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

FORMULA:

BITLSHIFT Function in Excel 1

RESULT:

BITLSHIFT Function in Excel 2

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.

previous BITLSHIFT Function in Excel                                                                                                                 next BITLSHIFT Function in Excel