RANDBETWEEN (random value)

<< Click to Display Table of Contents >>

RANDBETWEEN (random value)

Syntax:

RANDBETWEEN(LowerLimit, UpperLimit)

Description:

Returns an integer random number x in the range LowerLimitxUpperLimit

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:

RANDBETWEEN(1, 6) returns a random integer number in the range of 1 to 6, thereby simulating a dice roll.

See also:

RAND