How to Use BITRSHIFT Function in MS Excel 365?
Tags: bitrshiftfunctionine, excelfunctions
Published: 2020-08-14 11:25:11

---
title: How to Use BITRSHIFT Function in MS Excel 365?
published: true
date: 2020-08-13 06:31:47 UTC
tags: BITRSHIFTFunctioninE,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-bitrshift-function-in-ms-excel-365/
---

## BITRSHIFT Function in Excel:

In this tutorial, we will guide you to learn the usage of **BITRSHIFT Function in Excel 365** with its basic syntax, explanation, and examples. Let’s get into this article!! Get official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Jump To:

- [**BITRSHIFT – Function Definition**](#1)
- [**Syntax**](#2)
- [**Examples**](#3)
- [**Closure**](#4)

## BITRSHIFT – Function Definition:

- **BITRSHIFT** means it will shift bits by the specified number of times to the right. This function is similar to the [BITLSHIFT function](https://geekexcel.com/how-to-use-bitlshift-function-in-excel-365-with-examples/) but the only difference is BITLSHIFT is used to shift bits to the left.
- You can specify the shift\_amount to the input number either as a positive number or negative number.

## Syntax:

**=BITRSHIFT(number, shift\_amount)**

### Argument Description:

**Number** – The input number in which you want to shift bits to right by the specified number of bits.

**Shift\_amount** – Give the number of bits to be shifted. It should be an integer value.

### **Note:**

- If the value of shift\_amount is greater than 53, it returns **#NUM!** Error value.
- If you give any of the arguments as non-numeric value, it returns **#VALUE!** Error.
- You can assign a negative value to shift\_amount argument but it will shift the bits to the left.
- You can assign a positive number to the shift\_amount,  it will shift bits to the right.

## Examples:

See the following examples to understand this function easily.

### Example 1:

- Refer to the below screenshot. Here we have shown how BITRSHIFT function works.
- You can see the input (decimal) numbers in **Column**  **A** and its corresponding binary values in **Column**  **B**.
- For the value in **A2** cell, we have given the **shift\_amount** as **1** ( **positive**  **number** ), get the result using **BITRSHIFT** function in the active cell **D2**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Example-1.png)<figcaption id="caption-attachment-11604">Example 1</figcaption>

### Example 2:

- If the value of shift\_amount is greater than 53, it returns **#NUM!** Error value.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Example-2-1.png)<figcaption id="caption-attachment-11605">Example 2</figcaption>

### Example 3:

- If you give any of the arguments as non-numeric value, it returns **#VALUE!** Error.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/Example-3-1.png)<figcaption id="caption-attachment-11606">Example 3</figcaption>

## Closure:

In the above article, you can clearly learn the usage of **BITRSHIFT Function in Excel** 365 with its syntax, description, and examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Use BIN2HEX Function in Excel 365? {With example}](https://geekexcel.com/how-to-use-bin2hex-function-in-excel-365-with-example/)
- [How to Use DELTA Function in Microsoft Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-delta-function-in-microsoft-excel-365-with-examples/)