The RANDBETWEEN function returns a random integer within the specified range. Both arguments are number values.
RANDBETWEEN(lower, upper)
lower: The lower limit or bound.
upper: The upper limit or bound.
Notes
A new random number is generated each time any cell containing a formula is changed.
Example |
|---|
=RANDBETWEEN(1, 10) returns, for example, 8, 8, 9, 4, and 5 for five recalculations. |