|
<< Click to Display Table of Contents >> RANDBETWEEN (random value) |
Syntax:
RANDBETWEEN(LowerLimit, UpperLimit)
Description:
This returns a random integer x in the range LowerLimit ≤ x ≤ UpperLimit.
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:
RANDBETWEEN(1, 6) returns a random integer between 1 and 6, thus simulating the roll of a dice.
See also: