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