|
<< Click to Display Table of Contents >> 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: