Randbetween (Returns the rank of a number in a list of numbers)

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.

Syntax

=RANDOMBETWEEN(LowLimit,HighLimit)

Formatting

No special formatting is needed.

Example

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.