Summary

BITRSHIFT moves the bits of a number to the right by a chosen number of positions. In practical terms, shifting right reduces the value by powers of two and drops any remainder that falls off the right side.

This is useful when a value is stored in higher bit positions and you want to bring it back down into a simpler range. It is also a fast way to do whole-number division by powers of two when you are working with bit-based data.

Syntax

=BITRSHIFT(number, shift_amount)

number is the starting value. shift_amount is how many positions to move the bits.

A positive shift moves the bits to the right. A negative shift moves them left instead and behaves like BITLSHIFT. Excel still returns the result as a decimal number, so you do not have to convert it back manually after the shift.

Arguments

• number - [required] A non-negative integer.
• shift_amount - [required] An integer that tells Excel how far to shift.

number must be a whole number that is 0 or larger, and shift_amount must also be a whole number. Right shifts are often used to pull a value out of higher bit positions. Very large shifts can exceed Excel's supported limits and return #NUM!.

BITRSHIFT vs similar functions

BITRSHIFT is about moving bits down, not ordinary division with decimals:

Using BITRSHIFT

The easiest way to think about BITRSHIFT is that every right shift divides by 2 and drops any remainder. A shift of 1 halves the value, a shift of 2 divides by 4, and so on. That makes it useful when you want a clean whole-number result from a bit-based value.

It is also useful for extraction. If part of a number is stored in higher bits, shifting right moves that part closer to the low end where it is easier to read or combine with a mask. That is a common pattern when values are packed into one larger integer.

Microsoft also notes that BITRSHIFT works with non-negative integers up to 2^48 - 1, and if the absolute shift amount is greater than 53 Excel returns #NUM!. A negative shift amount acts like shifting left. Source: Microsoft Support, BITRSHIFT function.

Example 1 - Shift 10 right by 1

One right shift divides the value by 2.

=BITRSHIFT(10, 1) // Returns 5

Example 2 - Pull 255 out of a higher byte

This brings a value stored in higher bits back down.

=BITRSHIFT(65280, 8) // Returns 255

Example 3 - Divide 256 by 16

A shift of 4 divides the value by 2^4.

=BITRSHIFT(256, 4) // Returns 16

Example 4 - Shift 7 right by 1

This shows how the result is reduced with the remainder dropped.

=BITRSHIFT(7, 1) // Returns 3

Quick recap

• Moves bits right: BITRSHIFT pushes the pattern into lower positions.
• Acts like dividing by powers of two: A shift of 1 halves the value and drops any remainder.
• Useful for extraction: It helps pull higher-position values down into a simpler range.
• Negative shift amounts go the other way: Excel treats them like a left shift.
• Works within Excel's bitwise limits: Large values or large shifts can return #NUM!.