In this article, we will learn about how to use the BITRSHIFT function in Excel.
BITRSHIFT function in excel perform the Bitwise Right Shift operation on a decimal number and returns the decimal number after the operation performed.
Bitwise Right shift operation is performed on a binary number. Let’s consider a decimal number 4 and bit Right shift to be 2. As we know 4 is represented as 100 in binary. So 2 zeros will be reduced from the right of the binary number by shifting Right.
|Number||Binary number||shift_amount||Binary number after shift||Number after shift|
The BITRSHIFT function returns a Bitwise Right Shift of a decimal number upto shift_amount.
number1 : a positive integer number of base 10 (decimal number) to be shifted
shift_amount : an integer representing the amount of shift to occur on the number. This argument can be positive , zero or negative.
Here is the excel representation of the function
As you can the function returns 1 after the bitwise Right shift of 2 on 4.
You can use the DEC2BIN & BIN2DEC function in excel to understand the conversion operation.
Now let’s get more understanding of the function via using them in some examples.
Here we have some values as number & shift_amount in Columns. We need to get the bitwise Right shift operation on the given numbers using the BITRSHIFT function in excel
Use the formula :
A2 : number provided to the function as cell reference
B2 : number provided to the function as cell reference
The bitwise Right shift operation on 1 ( 01 ) by reducing one zero to the right of the number will be 0 ( 0 ).
Now copy the formula to other cells using the Ctrl + D shortcut key.
As you can see here the BITRSHIFT function returns the result of the input values.
Hope you understood how to use BITRSHIFT function and referring cell in Excel. Explore more articles on Excel mathematical conversion functions here. Please feel free to state your query or feedback for the above article.
How to use the ISEVEN function in Excel
How to Use ISERROR Function in Excel
How to Use ISNUMBER Function in Excel
How to use the ISNA Function
How to use the ISTEXT Function in Excel
How to use the ISODD Function in Excel
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.