Excel functions / Math
BITLSHIFT function
Moves the bits of a whole number to the left, which doubles it for every bit moved.
Syntax
=BITLSHIFT(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
BITLSHIFT moves the bits of a whole number to the left, which doubles it for every place moved. A negative shift moves them right.
Examples
Shift 5 two places left
A B C 1 n 2 5 20 In C2:
=BITLSHIFT(A2, 2)→ 20
Common mistakes
- Too large. The result must fit in 48 bits, or it is #NUM!.
BITLSHIFT 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: BITLSHIFT
- Danish: BITLSKIFT
- Dutch: BIT.VERSCHUIF.LINKS
- Finnish: BITTI.SIIRTO.V
- French: BITDECALG
- German: BITLVERSCHIEB
- Hungarian: BIT.BAL.ELTOL
- Italian: BIT.SPOSTA.SX
- Norwegian: BITVFORSKYV
- Polish: BIT.PRZESUNIĘCIE.W.LEWO
- Portuguese (Brazil): DESLOCESQBIT
- Portuguese (Portugal): BITDESL.ESQ
- Russian: БИТ.СДВИГЛ
- Spanish: BIT.DESPLIZQDA
- Swedish: BITVSKIFT
- Turkish: BİTSOLAKAYDIR
Try BITLSHIFT in the playground