BITRSHIFT

BITRSHIFT(number, shift_amount)

Returns the number shifted right by a number of bits.

number	The number to shift.
shift_amount	The amount to shift.

REMARKS

* Shifting a number right is the same as removing digits from the rightmost side of the binary representation.
* If "number" > (2^48)-1, then #NUM! is returned.
* If Abs(shift_amount) > 53, then #NUM! is returned.
* If "number" is not numeric, then #VALUE! is returned.
* If "shift_amount" is not numeric, then #VALUE! is returned.
* A positive "shift_amount" has the same effect as a negative "shift_amount".
* You can use the BITLSHIFT function to returns the number shifted left by a number of bits.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=BITRSHIFT(13, 2) = 3

1 - Shifts bits right for the number by stripping the specified rightmost digits of the number represented in binary. The number returned is represented in decimal. 13 is represented as 1101 in binary. Stripping the rightmost two digits results in 11, which is 3 in decimal.