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)