Related Function:

The RANDBETWEEN function returns a random integer number between the numbers you specify.

Syntax

=RANDBETWEEN(bottom,top)

Note: A new random real number is returned every time the worksheet is calculated.

Arguments

Argument Description
bottom The smallest integer RANDBETWEEN will return
top The largest integer RANDBETWEEN will return

Examples

  A B C
1 Formula Result Notes
2 =RANDBETWEEN(1,10) varies A random number between 1 and 10
3 =RANDBETWEEN(1,100) varies A random number between 1 and 100
4 =RANDBETWEEN(-1,2) varies A random number between -1 and 2

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if either of the supplied arguments are not recognized as numeric values
#NUM! Occurs if the supplied bottom argument is greater than the supplied top argument