Excel Function: RAND
The Excel function RAND generates a random number greater than or equal to 0 and less than 1.
Using the function alone generates a number from 0 to 1 (excluding 1):
By using RAND and a rounding function, it is also possible to generate whole numbers.
For example, to get a random integer between 1 and 10, use the following formula:
If you want to generate an integer between 1 and 50, simply replace 10 with 50 ...