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



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.