RAND function is a best fit to randomly generate numbers in Excel. It can generate evenly distributed numbers between 0 and 1.
Every time when you refresh your worksheet calculations, it will return a new random number. Yes, it’s a volatile function.
In the below example, we have simply used RAND to enter random numbers in a range.
In this function, there is no argument which you need to specify. While entering it you just need to add blank parentheses after the name of the function.
Apart from having numbers between 0 and 1 you can also use RAND for random numbers between two specific numbers.
In the below example, we have used it to create a formula which generates a random number between 50 and 100.
When you enter this formula in a cell it returns a number between 100 and 50 by multiplying the values returned by the RAND with the equation we have used.
To understand this formula we need to split it into three parts.
Related Formula Tips