Bit Right Shift Function in Excel 2013

The WorksheetFunction.Bitrshift Method is a new function introduced in Excel 2013. Bitrshift means bit right shift. This function is used to return a number shifted right 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 right.

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-bitrshift-function.jpg

Step 3

Now enter some digits, like this:

bitrshift-function-in-excel2013.jpg

Step 4

Now to convert the decimal number into a binary number we will use the DEC2BIN function like this:

excel2013-bitrshift-function1.jpg

Step 5

The output will be like this:

bitrshift-function-of-excel2013.jpg

Step 6

Now to shift the bits right by 1 we will use the BITRSHIFT function like this:

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

Step 7

The output will be like this:

excel2013-with-bitrshift-function.jpg

Step 8

If we want to shift the bits right by 2 then we will use the BITRSHIFT function like this:

excel2013-with-bitrshift-function1.jpg

Step 9

The output will then be like this:

 excel2013-with-bitrshift-function2.jpg

Up Next
    Ebook Download
    View all
    Learn
    View all