[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
RAND ( )
Description: Computes an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the cell's value is calculated.
Arguments: None.
Return Type and Value: number – An evenly distributed random real number greater than or equal to 0 and less than 1.
[Example:
RAND() results in 0.437337454
INT(RAND()*(6-1)+1) might result in 3
end example]