the BITRSHIFT function

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp


Welcome back to our frequent blog of Excel functions from A to Z. Today we look at the BITRSHIFT function.

The BITRSHIFT function

Time to find your antidote to recent BITLSHIFT work and you shouldn't feel bitterBITR?). This function first converts the number to binary and then removes a specific number of digits to the right of the binary number, In other words. tThis function returns a number shifted to the right by the specified number of bits.

The BITRSHIFT The function uses the following syntax to operate:

BITRSHIFT (number, shift amount)

The BITRSHIFT The function has the following arguments:

  • number: This is required and must be an integer greater than or equal to 0
  • shift_amount: additionally required. Must be a whole number.

It should be noted at the same time that:

  • shifting a number to the right is equivalent to erasing digits from the far right side of the binary representation of the number. As an example, a two-bit shift to the right in the decimal value 13 convert its binary value (1101) in 11, O 3 in decimal
  • if any of the arguments are outside your limitations, BITRSHIFT return the #ON ONE! error value
  • And number is greater than (2 ^ 48) -1, BITRSHIFT return the #ON ONE! error value
  • if the absolute value of shift_amount is greater than 53, BITRSHIFT return the #ON ONE! error value
  • if any of the arguments is a non-numeric value, BITRSHIFT return the #VALUE! error value
  • a negative number used as shift_amount The argument shifts the number of bits to the left.
  • a negative number used as shift_amount argument returns the same result as positive shift_amount argument for him BITLSHIFT function.

Please, see my example below:

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.