The RANDBETWEEN function returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.

RANDBETWEEN takes 2 required arguments and no optional arguments:

Syntax: RANDBETWEEN(bottom, top)

#1)
Using the RANDBETWEEN function:
#2)
The arguments for the RANDBETWEEN function are:
Argument Required? Description
bottom Required The smallest integer RANDBETWEEN will return.
top Required The largest integer RANDBETWEEN will return.

Summary

The RANDBETWEEN function returns a random integer number between the numbers you specify. A new random integer number is returned every time the worksheet is calculated.
comments powered by Disqus