Google Sheets

BITRSHIFT: Google Sheets Formulae Explained

How do you use BITRSHIFT in Google Sheets?

BITRSHIFT is used to shift a bit left or right. It takes an integer and a shift amount, and returns a new integer with the bits shifted. For example, BITRSHIFT(5,2) would return 3 because the 2nd bit of 5 (counting from the right) is shifted two places to the left, yielding 3.

What is the syntax of BITRSHIFT in Google Sheets?

BITRSHIFT is a function in Google Sheets that takes two numbers as input and shifts the bits of the first number to the right the number of times specified by the second number. For example, BITRSHIFT(12,3) would return the number 768 (12 shifted 3 times to the right).

What is an example of how to use BITRSHIFT in Google Sheets?

BITRSHIFT is a Google Sheets function that can be used to shift the bits of a number to the left or right. The function takes two arguments: the number that you want to shift and the number of bits that you want to shift. The number of bits that you want to shift can be either a positive or negative number. If you want to shift the bits to the left, you use a positive number. If you want to shift the bits to the right, you use a negative number.

Here is an example of how to use the BITRSHIFT function in Google Sheets. Suppose you have a number, 123, and you want to shift the bits two places to the right. This would result in the number, 11. You would use the BITRSHIFT function like this:=BITRSHIFT(123,2).

Here is another example. Suppose you have a number, -123, and you want to shift the bits two places to the left. This would result in the number, -112. You would use the BITRSHIFT function like this:=BITRSHIFT(-123,2).

When should you not use BITRSHIFT in Google Sheets?

BITRSHIFT is not intended to be used on text values. When you try to BITRSHIFT a text value, Google Sheets returns the #VALUE! error.

What are some similar formulae to BITRSHIFT in Google Sheets?

BITSHIFT is a formula that is used to shift bits to the left or right. In Google Sheets, there are some similar formulae that can be used to achieve the same result. The formulae that can be used are BITAND, BITLSHIFT, BITRSHIFT, and BITOR. These formulae all work by shifting bits to the left or right, and can be used to achieve the same result as BITSHIFT.

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.