Shifts the bits of a number to the right by a specified number of places.
Sintassi
BITRSHIFT(number, shift_amount)Argomenti
numberobbligatorio
The decimal integer to be shifted.
shift_amountobbligatorio
The number of bits to shift to the right.
The BITRSHIFT function returns a number shifted right by the specified amount of bits. Vacated bits on the left are filled with zeros, effectively performing a floor division by 2 raised to the power of the shift amount.
=BITRSHIFT(8, 2)→2Shifting the binary 1000 (8) right by 2 positions results in 0010 (2).
Enter the function
Type =BITRSHIFT( into a cell.
Define arguments
Input the decimal number and the number of positions to shift, separated by a comma.
Complete the formula
Close the parenthesis and press Enter to see the result.
If the shift amount is negative, the function will perform a left shift instead.