RAND

Returns an evenly distributed random number in the interval [0…1).

Syntax

RAND( ) → Number

Remarks

The RAND function is reevaluated every time the sheet is calculated.

Example

Formula

=RAND()
=RAND()*(10-1)+10

See Also

Function Reference
RANDBETWEEN Function