Author: Oscar Cronquist Article last updated on March 28, 2018

The BITRSHIFT function calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number.

Formula in cell D3:


Number 5 is 00000101 binary. Adding one zero to the left and removing the last digit you get 00000010 binary which is number 2.

Excel Function Syntax

BITRSHIFT(number, shift_amount)


number Required. The number you want to shift.
shift_amount Required. How many digits you want to shift the binary representation of the number.


The maximum number you can use is 2^48 = 2.81475E+14.