Skip to main content

RANDBETWEEN function

The RANDBETWEEN function is one of the math and trigonometry functions. The function returns a random number greater than or equal to lower-bound and less than or equal to upper-bound.

Syntax​

RANDBETWEEN(bottom, top)

The RANDBETWEEN function has the following arguments:

ArgumentDescription
bottomThe smallest integer value.
topThe largest integer value.

Notes​

If bottom is greater than top, the function will return #NUM! error.

How to apply the RANDBETWEEN function.

Examples​

The figure below displays the result returned by the RANDBETWEEN function.

RANDBETWEEN Function