Reader Level:
ARTICLE

Bitlshift Function in Excel 2013

Posted by Megha Goyal Articles | Office 2013 September 04, 2012
This article introduces the new function bit left shift (WorksheetFunction.Bitlshift) function in Excel 2013.
  • 0
  • 0
  • 2137

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

Trending up