Excel function RAND
The RAND function only does one thing. It generates a random number between 0 and 1.
Select the RAND function, and this window will appear:
Just click OK. A number will be generated.
By using RAND with a rounding function, we can also generate integers.
For example, use the following formula to generate a random number between 1 and 6:
If you would like to generate an integer between 1 and 50, simply replace 6 with 50 ...