RAND (random value)

<< Click to Display Table of Contents >>

RAND (random value)

Syntax:

RAND()

Description:

Returns a random number ≥ 0 and < 1.

A new random number will be generated every time the document is recalculated.

Tip: By using the ribbon command Formula | group Update| Update data | Update calculations you can manually recalculate a document.

Example:

RAND() returns a random number.

The following formula returns a random integer number in the range of 1 to 6, thereby simulating a dice roll:

INT(RAND()*6+1)

Tip: This can be done more easily with RANDBETWEEN(16, 6).

See also:

RANDBETWEEN