RAND Formula in Excel
Wednesday, Jul 08
Win Loss Sparklines Chart

How to Use the RAND Formula in Excel

The RAND formula in Excel is used to insert random numeric values which are greater than 0 but less than 1.

This can be used if you are trying to insert random percentages in a worksheet because decimals in excel can also be treated as percentages.

Note that every time you refresh the screen, the data will randomize. Therefore, if you are looking to randomize data once and then store it then the best practice is to randomize the data, copy it, and paste special the values somewhere else in the worksheet.

Formula explanation:

RAND: There is no required value to use in this formula. You just need to type =RAND() to use the formula.

Example :

In this example, we are going to insert a random small values (i.e. between 0 and 1) into a data table below.


Formula Implementation:

Overall, if you just need randomized data, it is suggested to use this random formula but then copy it and paste special values of that somewhere else so we at least have that data stored of the random information.

I hope that helps. Please leave a comment below with any questions or suggestions. For more in-depth Excel training, checkout our Ultimate Excel Training Course here. Thank you!



Learn 10 great Excel techniques that will wow your boss and make your co-workers say, “how did you do that??”
Plus weekly updates to help you learn Excel.

Download the eBook

Contact Us

Please reach out to us with questions and comments using the form.
Commerce Curve.

4 + 6 =