The RAND function returns a random decimal number that is greater than or equal to 0 and less than 1.
This function can be useful for data generation, modeling, and other tasks where randomness is required.
Syntax
RAND()
No arguments are allowed for this function.
Example of use
If you want to get a random number, use
=RAND()
The function will return a random value, for example, 0.123456789.
Notes
–Every time you open a file, change the value of any cell, insert or delete rows or columns, rename or move a sheet, manually recalculate data, or change the calculation mode from “Calculate manually” to “Calculate automatically”, the RAND function will generate a new random number.
–If you want to record a random number, you can copy the cell with the formula and paste only the value.