BITRSHIFT Function in Excel

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,

NumberShift_amountResult
13-126
13013
1316
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.

NumberShift_amountResult
00001101-100011010
00001101000001101
00001101100000110

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.