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 2222Purpose 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)
