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.

=RAND()

*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%.

Download this sample file from here to learn more.

*This function is the part of the list of Excel’s top 100 functions [with examples] and from here you can also learn some amazing **formula tips**.*

Related Functions

- ABS Function: It converts a number into an absolute number. An absolute value of a number is the number without its sign [...]
- TRUNC Function: It truncates a number to an integer by removing the fractional part of the number. In simple word, it returns on integer part from a value [...]

Related Formula Tips

- Generate Random Letters in Excel: By using a combination of RANDBETWEEN and CHAR you create a formula to generate random letters [...]
- Convert Negative Number into Positive in Excel: There are more than six different methods to convert a negative number into positive [...]