Author: Oscar Cronquist Article last updated on May 04, 2022

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.