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:

rand function - rand

Just click OK. A number will be generated.

rand - rand

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:

rand integer - rand

If you would like to generate an integer between 1 and 50, simply replace 6 with 50 ...