RANDBETWEEN
What Does It Do ?
This function produces a random whole number between two specified numbers.
The random number will change each time the spreadsheet is recalculated or F9 is pressed.
=RANDOMBETWEEN(LowLimit,HighLimit)
No special formatting is needed.
The following table shows how the =RANDBETWEEN() has been used to generate six
numbers to use for the National Lottery.
Note that the function does not check to ensure all numbers are unique, the same number
could be generated twice or more.