The Excel BITRSHIFT function shifts a number by the specified number of bits, effectively halving or doubling the number a specified number of times.
Returns a number shifted right by some number of bits
=BITRSHIFT (number, shift_amount)
number - The number to be bit shifted.
shift_amount - The amount of bits to shift to the right, if negative shifts bits to the left instead.
Integer underflow results in loss of the least significant bits. For example, if the number 3 is shifted right by one, then the right-most binary bit is truncated and lost. For any bit shift that results in integer overflow, where the result is larger than 2^48 -1, the function returns the #NUM! error.
How It Works
The shift_amount can either be positive or negative. If a negative number is provided, the bits are shifted to the left instead.
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.