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:


Excel Function Syntax



The RAND function has no arguments.