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:
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.