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. 