Manuals/calci/BITRSHIFTZ

Revision as of 15:08, 4 December 2017 by Devika (talk | contribs)
BITRSHIFTZ(a,b)


  • where is the number to be shifted right
  • is number of bits to be shifted


Description

  • BITRSHIFTZ() returns a number shifted to the right, by number of digits specified in the argument.
  •   should be an integer greater than or equal to 0.
  •   must be an integer value.
  • Shifting a number right is equivalent to to removing digits from the rightmost side of the binary representation of the number.

For example, a 1-bit shift to the right on the decimal value 4 converts its binary value (100) to 010, or 2 in decimal.

  • If either argument is a non-numeric value, BITRSHIFTZ returns the #VALUE! error value.

Examples

  1. =BITRSHIFTZ(10,3) = 1
  2. =BITRSHIFTZ(45,32) = 45
  3. =BITRSHIFTZ(-21,5) = 134217727
  4. =BITRSHIFTZ(17,-2) = 0


See Also


References