In this post, you will learn about the BITRSHIFT function, the formula syntax, and usage of the function in Microsoft Excel.
BITRSHIFT Function in Excel
The BITRSHIFT function in Excel shifts Right by the specified amount of Shift in bits of a given number and returns the decimal value of the number.
Syntax
=BITRSHIFT(number, shift_amount)
Arguments:
- Number Required. Number must be an integer greater than or equal to 0.
- Shift_amount Required. Shift_amount must be an integer.
Version
Excel 2013 and above
Note:
- For any bit shift that results in integer overflow, where the result is larger than 2^48 -1, the function returns the #NUM! error.
- #VALUE! error when the number or shift_amount arguments are non-numeric
- #NUM! error when the absolute value of shift_amount is > 53
How to use BITRSHIFT Function in Excel?
Take a look at the table below,
| Number | Shift_amount | Result |
| 13 | -1 | 26 |
| 13 | 0 | 13 |
| 13 | 1 | 6 |
Formula: BITLSHIFT (A1, B1)
Use this above formula while working in Excel worksheet. Enter the formula in the cell C1.
The number column is the number that you need to manipulate and the Shift_amount column is the amount of digits that you to need to right shift the ‘Number’.
The result column is the actual result of the BITRSHIFT.
Now, let’s see what happens inside the process.
| Number | Shift_amount | Result |
| 00001101 | -1 | 00011010 |
| 00001101 | 0 | 00001101 |
| 00001101 | 1 | 00000110 |
The number 13 has the binary value ‘00001101’, and when we do a negative right shift to this binary value, the resultant would be “00011010” i.e, the right shift runs for the amount of time you declare in the shift_amount Column.
