Excel Function: RAND

The Excel function RAND generates a random number greater than or equal to 0 and less than 1.



Usage examples

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:

rand integer

If you want to generate an integer between 1 and 50, simply replace 10 with 50 ...