Article updated on April 24, 2018

The RAND function calculates a random real number greater than or equal to 0 and less than 1.

The function is volatile meaning a new random real number is returned every time the worksheet is calculated.

Formula in cell B3:

=RAND()

Excel Function Syntax

RAND()

Arguments

The RAND function has no arguments.