## What is BITRSHIFT function in Excel?

The **BITRSHIFT **function is one of the ** Engineering** functions of Excel.

It Returns a number **shifted right by shift amount** bits.

We can find this function in **Engineering **of insert function Tab.

## How to use BITRSHIFT function in excel

- Click on an
**empty cell**(like F5).

2. Click on the** fx icon** (or press** shift+F3**).

3. In the **insert function tab** you will see all functions.

4. Select **ENGINEERING **category.

5. Select **BITRSHIFT **function.

6. Then select **ok**.

7. In function arguments Tab you will see **BITRSHIFT function**.

8. Number is the **decimal representation of the binary** number you want to evaluate.

9. Shift_amount is the **number of bits** that you want to **shift **Number right by.

10. You will see the **results **in the formula result section.

## Examples of BITRSHIFT function in Excel

**Example 1:**

**How to use BITRSHIFT function in** **excel**

You can see examples of **BITRSHIFT** function below:

```
bitrshift(A2,B2) ----->>>>answer is 555
bitrshift(A3,B3) ----->>>>answer is 277
bitrshift(A4,B4) ----->>>>answer is 138
bitrshift(A5,B5) ----->>>>answer is 69
bitrshift(A6,B6) ----->>>>answer is 1111
bitrshift(A7,B7) ----->>>>answer is 2222
```

## Purpose of **BITRSHIFT** function

**BITRSHIFT**

It Returns a number **shifted right by shift amount** bits.

## Return value of **BITRSHIFT** function

**BITRSHIFT**

It returns a number.

## Arguments of **BITRSHIFT** function

**BITRSHIFT**

This function has just **2 **Argument.

The **argument **of BITRSHIFT function is **number**.

Number is the **decimal representation of the binary** number you want to evaluate.

Shift_amount is the **number of bits** that you want to **shift **Number right by.

The argument of BITRSHIFT function is **required **and not optional.

```
BITRSHIFT(number) = number
```

## Version of excel supports **BITRSHIFT** function

**BITRSHIFT**This function is available for all excel **versions **(2003-2019)

## Errors in **BITRSHIFT** function

**BITRSHIFT**