BITRSHIFT
Returns a value number shifted right by shift_amount bits.
EngineeringEngineering & Science
What it does
Shifts the bits of a number to the right (equivalent to dividing by 2^shift_amount).
Syntax
BITRSHIFT(number, shift_amount)
Arguments
number(number) — Integer to shift.shift_amount(number) — Number of bits to shift.
Examples
Bitwise Right Shift
Shift 13 (1101) right by 2 bits.
FORMULA
=BITRSHIFT(13, 2)
RESULT
3
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Num | Shift |
| 2 | 13 | 2 |