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

=BITRSHIFT(number,shift_amount)

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

Shift_amount Required. Must be an integer.

Example

Below are some examples of this function.

Figure 1 – Excel BITRSHIFT function

Explanation

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

Notes:

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

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc