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

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

  1. Shift 5 two places left

    ABC
    1n
    2520

    In C2: =BITLSHIFT(A2, 2) → 20

    Try this example

Common mistakes

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.

Translate a whole formula

Try BITLSHIFT in the playground

Related functions