SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / RANDBETWEEN
In This Topic
    RANDBETWEEN
    In This Topic

    This function returns a random number between the numbers you specify.

    Syntax

    RANDBETWEEN(lower,upper)

    Arguments

    This function has these arguments:

    Argument Description
    lower Lower number of two numbers between which a random number is chosen; this number must be less than upper
    upper Upper number of two numbers between which a random number is chosen

    Remarks

    This function returns a new random number every time the sheet is calculated.

    This functions returns an integer value. The first argument must be less than the second argument.

    For more information, refer to Volatile Functions.

    Data Types

    Accepts numeric data for both arguments. Returns numeric data.

    Examples

    RANDBETWEEN(A1,B2)

    RANDBETWEEN(10,20)

    RANDBETWEEN(10,40)*100

    INT(RANDBETWEEN(1,10)*100)

    See Also