Spread.NET 17 Formula Reference
Formula Functions / Functions A to C / BITRSHIFT
In This Topic
    In This Topic

    This function calculates the value shifted right by specified number of bits.


    BITRSHIFT(value, shift_amt)


    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.


    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.


    BITRSHIFT(5,2) gives the result 1.

    BITRSHIFT(15,2) gives the result 3.

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.