Spread Formula Reference
Formula Functions / Functions R to S / 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.

    This is a volatile function with version 2.5 or later. 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)

    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

    RAND | Math and Trigonometry Functions