Difference between revisions of "Manuals/calci/BITRSHIFTZ"
Jump to navigation
Jump to search
| Line 16: | Line 16: | ||
== Examples == | == Examples == | ||
| − | #= | + | #=BITRSHIFTZ(10,3) = 1 |
| − | #= | + | #=BITRSHIFTZ(45,32) = 45 |
| − | #= | + | #=BITRSHIFTZ(-21,5) = 134217727 |
| − | #= | + | #=BITRSHIFTZ(17,-2) = 0 |
Revision as of 15:08, 4 December 2017
BITRSHIFTZ(a,b)
- where is the number to be shifted right
- is number of bits to be shifted
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
- =BITRSHIFTZ(10,3) = 1
- =BITRSHIFTZ(45,32) = 45
- =BITRSHIFTZ(-21,5) = 134217727
- =BITRSHIFTZ(17,-2) = 0
See Also
References