Navigation:  Formula Reference > Spreadsheet Formula Functions >

RANDBETWEEN

Previous pageReturn to chapter overviewNext page

 

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

RAND