The WorksheetFunction.Bitlshift Method is a new function in Excel 2013. This function does a bit left shift in Excel 2013. This function is used to return a number shifted left by shift_amount bits. This function takes the two arguments, a number (number) to be shifted and a shift amount (shift_amount). The shift_ amount indicates the number of bits to shift the binary digits to the left.
Let's have a look at the following steps.
Step 1
First go to Excel 2013.
Step 2
Now select blank workbook templates from the available templates.
Step 3
Now write some digits like this:
Step 4
Now to convert the decimal number into binary digits we need to use the DEC2BIN function like this:
Step 5
The output will be like this:
Step 6
Now to determine the value of the bits shifted left by 1 position we need to use the the BITLSHIFT function like this:
Step 7
The output will be like this:
Step 8
If we want to determine the value of the bits shifted left by 2 positions we need to use the the BITLSHIFT function like this:
Step 9
The output will be like this: