Tackle 2024 with new knowledge – take advantage of Learnesys’ fall campaign on the All Courses package. Read more here.

# 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.