Returns the value of the specified argument shifted to the right by the specified number of bits.
Syntax
 Copy Code
|
|---|
FUNC( Integer x, Integer bits ) → Integer |
Parameters
- x
- Required. The number to shift. Must be greater than or equal to zero.
- bits
- Required. The number of bits to shift.
Remarks
Shifting a number to the right is equivalent to removing digits from the rightmost side of the binary representation of the number. For example, shifting the number 14 to the right by one bit, converts the binary value of 14 (1110) to 111, or 7 in decimal.
If any of the arguments violates its constraints, BITRSHIFT returns the #NUM! error value. If the specified values are not integer, they are automatically converted. If bits is negative, the function shifts the specified number to the left instead.
Example
| Formula
Copy Code
|
|---|
=BITRSHIFT(43,2) |
See Also
Function Reference
BITAND Function
BITXOR Function
BITLSHIFT Function