Rand Formula in Excel
Link to full course: https://commercecurve.com/ultimate-ex...
Take this course if you're looking to accelerate your career with a complete course that integrates finance and accounting topics with end-to-end Excel training through the application of concrete examples of real world companies.
The RAND formula 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.
=RAND()
RAND: There is no required value to use in this formula. You just need to type =RAND() to use the formula.