Excel functions / Math
BITRSHIFT function
Moves the bits of a whole number to the right, which halves it for every bit moved and drops the remainder.
Syntax
=BITRSHIFT(number, shift_amount)
Arguments
number: A whole number, 0 or more.shift_amount: How many bits to move. A negative amount moves the other way.
When to use it
BITRSHIFT moves the bits of a whole number to the right, halving it for every place and dropping the remainder.
Examples
Shift 13 two places right
A B C 1 n 2 13 3 In C2:
=BITRSHIFT(A2, 2)→ 3
Common mistakes
- Decimals. The number must be a whole number of 0 or more.
BITRSHIFT in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: BITRSHIFT
- Danish: BITRSKIFT
- Dutch: BIT.VERSCHUIF.RECHTS
- Finnish: BITTI.SIIRTO.O
- French: BITDECALD
- German: BITRVERSCHIEB
- Hungarian: BIT.JOBB.ELTOL
- Italian: BIT.SPOSTA.DX
- Norwegian: BITHFORSKYV
- Polish: BIT.PRZESUNIĘCIE.W.PRAWO
- Portuguese (Brazil): DESLOCDIRBIT
- Portuguese (Portugal): BITDESL.DIR
- Russian: БИТ.СДВИГП
- Spanish: BIT.DESPLDCHA
- Swedish: BITHSKIFT
- Turkish: BİTSAĞAKAYDIR
Try BITRSHIFT in the playground