RAND

Description: Returns an evenly distributed number greater than or equal to 0 and less than 1. There are no arguments associated with this function. A new random real number is returned every time the worksheet is calculated.

Syntax: RAND()

Remarks:

  • To generate a random real number between a and b, use:

RAND()*(b-a)+a

Example:

  • RAND()= 0.301044 [a random number between 0 and 1 (varies)]