- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
-
Engineering Functions
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BITAND
- BITLSHIFT
- BITOR
-
BITRSHIFT
- BITXOR
- COMPLEX
- CONVERT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DELTA
- ERF
- ERF.PRECISE
- ERFC
- ERFC.PRECISE
- GESTEP
- HEX2BIN
- HEX2DEC
- HEX2OCT
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCSC
- IMCSCH
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSUB
- IMSUM
- IMTAN
- OCT2BIN
- OCT2DEC
- OCT2HEX
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
BITRSHIFT
This function calculates the value shifted right by specified number of bits.
Syntax
BITRSHIFT(value, shift_amt)
Arguments
This function has the following arguments:
Argument | Description |
|---|---|
value | Refers to the value that you want to shift. |
shift_amt | Refers to the number of bits to be shifted by. |
Remarks
Shifting a number right is similar to removing digits from right end of the binary representation of the number. If shift_amt is a negative number, then value will be shifted to left.
Data Types
Accepts numeric data for both arguments. Returns numeric data.
Examples
BITRSHIFT(5,2) gives the result 1.
BITRSHIFT(15,2) gives the result 3.