Reader Level:
Article

Bitlshift Function in Excel 2013

By Megha Goyal on Sep 04, 2012
This article introduces the new function bit left shift (WorksheetFunction.Bitlshift) function in Excel 2013.

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.

excel2013-bitlshift-function.jpg

Step 3

Now write some digits like this:

bitlshift-function-in-excel2013.jpg

Step 4

Now to convert the decimal number into binary digits we need to use the DEC2BIN function like this:

excel2013-bitlshift-function1.jpg

Step 5

The output will be like this:

bitlshift-function-of-excel2013.jpg

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:

use-of-bitlshift-function-in-excel2013.jpg

Step 7

The output will be like this:

excel2013-with-bitlshift-function.jpg

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:

excel2013-with-bitlshift-function1.jpg

Step 9

The output will be like this:

 excel2013-with-bitlshift-function2.jpg

COMMENT USING