Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Excel BITRSHIFT Function

Excel BITRSHIFT Function changes a number into equivalent binary, shifts right by a specified number of bits, then converts back to a number.

Generic Formula


Number Required. Must be a positive integer or equal to 0

Shift_amount Required. Must be an integer.


Below are some examples of this function.

Figure 1 – Excel BITRSHIFT function


The formula in C2 is =BITRSHIFT(A2,B2) returns 5 because:

  • 90 is presented 1011010 in binary
  • 1011010 is stripped the rightmost 4 digits and results in 101
  • 101 is 5 in decimal

The return C5 is 24 because the shift_amount value is negative, which shifts bits to the left instead.

  • 6 is presented 110 in binary
  • 110 is stripped the leftmost by 2 digits and results in 11000
  • 11000 is 24 in decimal

You can use DEC2BIN to check the binary form of the integer.

Figure 2 – Excel BITRSHIFT function


The supplied Number must be a positive integer and smaller than (2^48)-1.

Leave a Comment


Subscribe to

Get updates on helpful Excel topics

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc