<< 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: