Excel BITRSHIFT function

Function              BITRSHIFT

Description        Excel BITRSHIFT function returns a number shifted right by some number of bits.

Syntax                  BITRSHIFT(number, shift_amount)

Number               Required. Must be an integer, greater than or equal to zero.

Shift amount     Required. Shift_amount must be an integer.

Example:

=BITRSHIFT(34,2) = 8

=BITRSHIFT(34,-2) = 136

Usage Notes:

• Shifting a number right is basically removing digits from right side of the binary form of the number.
• If either argument is outside their constraints, BITRSHIFT returns the #NUM! error value.
• BITRSHIFT returns the #NUM! error value if Number is greater than (2^48)-1.
• BITRSHIFT returns the #NUM! error value when the absolute value of Shift_amount is greater than 53.
• BITRSHIFT returns the #VALUE! error value when input is a non-numeric value.
• A negative number used as the Shift_amount argument shifts the number of bits to the right.
• A negative number used as the Shift_amount argument returns the same result as a positive shift_amount argument for the BITLSHIFT function.