The RAND function returns a random number that is greater than or equal to 0 and less than 1.
RAND()
Notes
The RAND function does not have any arguments. However, you must include the parentheses.
A new random number is generated each time any cell containing a formula is changed.
Example |
|---|
=RAND() returns, for example, 0.939067584462464, 0.585520338732749, 0.989037489518523, and 0.691605266649276 for four recalculations. |