BITRSHIFT |
BITRSHIFT(number, shift_amount) |
Returns the number shifted right by a number of bits. |
number | The number to shift. |
shift_amount | The 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 |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top