Excel BITRSHIFT Function

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

  1. Click on an empty cell (like F5).
empty cell in excel

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

fx icon in excel

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

insert function tab in excel

4. Select ENGINEERING category.

5. Select BITRSHIFT function.

6. Then select ok.

excel BITRSHIFT function

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.

How to use BITRSHIFT function in excel

Examples of BITRSHIFT function in Excel

Example 1:

How to use BITRSHIFT function in excel

You can see examples of BITRSHIFT function below:

Examples of BITRSHIFT function in Excel
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

It Returns a number shifted right by shift amount bits.

Return value of BITRSHIFT function

It returns a number.

Arguments of BITRSHIFT function

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

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

Errors in BITRSHIFT function

BITRSHIFT related functions 

Leave a Reply

Your email address will not be published. Required fields are marked *