Uniform Random Numbers

The RAND function returns numbers from the interval [0,1], and if you need to generate numbers from another interval, you should use the following formula:

=RAND() * (b-a) + a

This will return random numbers from the interval [a,b] – greater than or equal to a, and less than b.

To generate random integer, you should use the following formula:

=ROUNDUP(RAND() * (b-a) + a,0)