BITRSHIFT

BITRSHIFT(number, shift_amount)

Returns the number shifted right by a number of bits.

numberThe number to shift.
shift_amountThe amount to shift.

REMARKS
* Shifting a number right is the same as removing digits from the rightmost side of the binary representation.
* If "number" > (2^48)-1, then #NUM is returned.
* If Abs(shift_amount) > 53, then #NUM is returned.
* If "number" is not numeric, then #VALUE is returned.
* If "shift_amount" is not numeric, then #VALUE is returned.
* A positive "shift_amount" has the same effect as a negative "shift_amount".
* You can use the BITLSHIFT function to returns the number shifted left by a number of bits.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 A
1??


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top