Spread Formula Reference
RANDBETWEEN
Formula Functions > Functions R to S > RANDBETWEEN

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