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.
- First of all, when it deducts the lowest number from the highest number you get the difference between both of them.
- Then secondly it multiplies that difference with the random number returned after the subtraction.
- And thirdly, add that number with the lowest number left in the third part of the equation.
- RAND is a volatile function which will recalculate whenever workbook is open or a calculation made. In simple words, whenever you hit enter or refresh your workbook it will recalculate the values.
- If you don't want RAND to recalculate numbers, you can convert those number into values by using paste special or after entering RAND Function into the cell press F9 (in edit mode).
- To enter the random numbers in a selected range. Just select the range first, then type =RAND() and press Ctrl + Enter.
- By using RAND you can also generate random percentage from 0% to 100%.
Related Formula Tips