Spread.NET 17 Formula Reference
Formula Functions / Functions R to S / RAND
In This Topic
    RAND
    In This Topic

    This function returns an evenly distributed random number between 0 and 1.

    Syntax

    RAND()

    Arguments

    This function does not accept arguments.

    Remarks

    This function returns a new random number.

    To generate a random real number between x and y, with y greater than x, use the following expression:

    RAND()*(y-x)+x

    To generate a random integer between x and y, with y greater than x, use the following expression:

    INT((y-x+1)*RAND()+x)

    This is a volatile function with version 2.5 or later. For more information, refer to Volatile Functions.

    Data Types

    Does not accept data. Returns numeric data.

    Examples

    RAND()

    RAND()*100

    INT(RAND()*100)

    Version Available

    This function is available in product version 1.0 or later. This function is a volatile function in version 2.5 or later.

    See Also

    RANDBETWEEN | INT | Math and Trigonometry Functions