## Excel BITRSHIFT function

The** BITRSHIFT function** returns the given number shifted right by the specified number of bits.

**Note:** This function is only available in Excel 2013 and later versions.

#### Syntax

**BITRSHIFT(number, shift_amount)**

#### Arguments

**Number**(required): This argument must be in decimal form greater than or equal to 0;**Shift_amount**(required): An integer represents the number of bits to be shifted. It allows positive integer and negative integer:

**Positive integer**: it shifts the number of bits to the right.

**Negative integer**: it shifts the number of bits to the left.

#### Remarks

**#NUM!**error value occurs when either of the following conditions is met:

**#VALUE!**error value occurs if either of the supplied numbers is non-numeric.

#### Return value

It returns a numeric value.

#### Example

To shift the decimal numbers in column B by the number of bits listed in column C as shown in the table below, you can do as follows.

Select a cell (says D6 in this case), enter the formula below and press **Enter** to get the first result. Select this result cell and then drag its AutoFill Handle down to get other results.

**=BITRSHIFT(B6,C6)**

**Notes:**

1) Arguments in the formula above are supplied as cell references that contain numbers. However, you can change the formula in D6 as follows:

**=BITRSHIFT(1,1)**

2) How does this BITRSHIFT function work?

Take the formula in D6 as an example: **=BITRSHIFT(B6,C6)**

**Tips:**You can apply the DEC2BIN function to easily convert a decimal number to binary in Excel.

**Tips:**You can apply the BIN2DEC function to easily convert a binary to decimal in Excel.

The following table shows how this function works in details.

#### Related Functions

**Excel BITOR function**

The BITOR function returns the bitwise ‘OR’ of two given numbers.

**Excel BITXOR function**

The BITXOR function returns the bitwise ‘XOR’ of two given numbers.

**Excel BITLSHIFT Function**

The BITLSHIFT function returns a decimal number shifted left by a specified number of bits.

**Excel BITAND function**

The BITAND function returns a decimal number representing the bitwise 'AND' of two supplied numbers.

**The Best Office Productivity Tools**

#### Kutools for Excel - Helps You To Stand Out From Crowd

**Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...**

#### Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.