How to use the BITRSHIFT function
Author: Oscar Cronquist Article last updated on May 11, 2022
The BITRSHIFT function calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number.
Formula in cell D3:
=BITRSHIFT(B3, C3)
Number 5 is 00000101 binary. Adding one zero to the left and removing the last digit you get 00000010 binary which is number 2.
Excel Function Syntax
BITRSHIFT(number, shift_amount)
Arguments
| number | Required. The number you want to shift. |
| shift_amount | Required. How many digits you want to shift the binary representation of the number. |
Comments
The maximum number you can use is 2^48 = 2.81475E+14.
Functions in 'Engineering' category
The BITRSHIFT function function is one of many functions in the 'Engineering' category.
Converts a binary number to the decimal number system.
Converts a binary number to hexadecimal.
Converts a binary number to octal.
Calculates a bitwise 'AND' of two numbers.
Calculates a number whose binary representation is shifted left by a specified number of bits.
Performs a bitwise 'OR' of two numbers.
Calculates the number where the binary equivalent is shifted right by a specified number of bits and then converted back to a number.
Calculates a decimal number that is a result of a bitwise comparison "XOR" of two numbers.
Returns a complex number based on a real and imaginary number.
Converts a number from one measurement system to another.
Converts a decimal number to a binary number.
Converts a decimal number to a hexadecimal number.
Converts a decimal number to an octal number.
Evaluates whether two numerical values are equal.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form