Navigation:  Formulas and functions > Functions from A to Z > RAND (random value)

Syntax:

RAND()

Description:

This returns a random number ≥ 0 and < 1.

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

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

Example:

INT() returns a random number.

The following formula returns a random integer between 1 and 6, thus simulating the roll of a dice.

INT(RAND()*6+1)

Tip: However, this is easier with RANDBETWEEN(16, 6).

See also:

RANDBETWEEN