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:

Argument	Description
bottom	The smallest integer value.
top	The largest integer valuew.

Notes

If bottom is a 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.