Fill in your e-mail address and telephone and we will give you 7 days free access to our course The Excel Functions Guide.

# RAND

See more Excel functions
Share

In order to generate random numbers, we use the RAND function, which produces a random number between 0 and 1.
Unlike many other functions, it does not contain any arguments. Instead, we simply write Equals, RAND, and two empty parentheses.
This gives us a random sequence of digits. If we copy the function downwards, each of the new cells will contain a different set of digits.
Also note that the first cell also changed. This is because the function is remade every time any cell on the sheet is updated.
If we want to copy just the values that have been generated, we’ll have to copy, and paste values.
Since the random number is between 0 and 1, we can decide how large of a value the maximum number will be, by simply multiplying the RAND function by whatever number we want…
In this lesson we have gone through the RAND function, which lets us generate random numbers.