The RAND function returns a real random number greater than or equal to 0 and less strict than 1 drawn from a continuous uniform distribution.
Syntax
RAND()
Parameters
The RAND function does not accept arguments.
Returned value
The RAND function returns a real number.
Additional Information
The returned value changes each time the cell containing the function is recalculated. This will occur when data read from an external source is refreshed, when new data sources are added, or when a manual refresh is forced.
Examples
In this example we generate a random number:
To generate a random number between two numbers A and B (assuming that A < B) the following formula can be used:
number = RAND () * (B - A) + A
Thus, to generate a random number between 4.25 and 7.50, for example, we would use the following formula:
Related functions
Category
Mathematical and trigonometric
