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

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

  1. Shift 13 two places right

    ABC
    1n
    2133

    In C2: =BITRSHIFT(A2, 2) → 3

    Try this example

Common mistakes

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.

Translate a whole formula

Try BITRSHIFT in the playground

Related functions