<< Click to Display Table of Contents >> RANDBETWEEN (random value) |
Syntax:
RANDBETWEEN(LowerLimit, UpperLimit)
Description:
Returns an integer random number x in the range LowerLimit ≤ x ≤ UpperLimit
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: