Spread Formula Reference
Formula Functions / Functions A to C / BITLSHIFT
In This Topic
    BITLSHIFT
    In This Topic

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

    Syntax

    BITLSHIFT(value, shift_amt)

    Arguments

    This function has the following arguments:

    Argument Description
    value Refers to a value that you want to shift.
    shift_amt Refers to a number of bits to be shifted by.

    Remarks

    Shifting a number left is similar to adding zeros (0) at right end of the binary representation of that number. If shift_amt is a negative number, then the value will be shifted to right.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    BITLSHIFT(3,5) gives the result 96.

    BITLSHIFT(1,4) gives the result 16.

    Version Available

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