Learn How to Use Microsoft Excel BITRSHIFT Function
In this article, you will learn how to use the Microsoft Excel BITRSHIFT function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel BITRSHIFT function return value and syntax with the help of some examples.
Microsoft Excel BITRSHIFT Function
The main function of the Microsoft Excel BITRSHIFT function is used to return a number shifted right by some number of bits. So with the help of the BITRSHIFT function, you can able to shift a number by the specified number of bits. Also, you can effectively half or double the number specified number of times.
Return Value of BITRSHIFT Function
The return value will be the decimal number.
Syntax of BITRSHIFT Function
Where the argument:
number: It is the number to be bit shifted.
shift_amount: It is the amount of bits to be shifted right, in case negative it shifts the bits to the left instead.
How to Use Microsoft Excel BITRSHIFT Function?
The shift_amount can be negative or positive and if a negative number is provided, the bits are shifted to the left. For any bit shift that results in an integer overflow, where the result is greater than 2^48-1, the BITLSHIFT function will return the #NUM! error.
Check out the list of all other articles:
- Learn How to Lookup With Variable Sheet Name in Microsoft Excel
- Learn How to Lookup Value Between Two Numbers in Microsoft Excel
- Learn How to Lookup Up Cost for Product or Service in Microsoft Excel
- Learn How to Lookup Lowest Value in Microsoft Excel
- Learn How to Lookup Lowest Sunday Tide in Microsoft Excel
- Learn How to Lookup Latest Price in Microsoft Excel
- Learn How to Lookup Last File Version in Microsoft Excel
- Learn How to Lookup Entire Row in Microsoft Excel