Excel like a finance pro.
← The libraryPractice · 2 questions →
Engineering function
BITRSHIFT
Returns a number shifted right by the specified number of bits.
Rarely usedDifficulty 1350 · AdvancedUsage rank #423 of 520
When to use it
Shifts bits right, dividing by 2 for each position and dropping the remainder.
The shape of it
- Syntax
=BITRSHIFT(number, shift_amount)
Worked examples
Simple
=BITRSHIFT(13,2) → 3
1101 becomes 11.
Power of two
=BITRSHIFT(1024,10) → 1
Back down from 2^10.
High nibble
=BITRSHIFT(255,4) → 15
The high nibble of a byte.
Worth knowing
- Same as INT(number/2^shift).
- Unpack: high = BITRSHIFT(packed,8), low = BITAND(packed,255).
- Negative shift moves left.
Where it goes wrong
- #NUM! for negatives or shift beyond ±53.
- #VALUE! for text.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.