RAND

See also A-Z Spreadsheet Function List

Description Returns a number selected randomly from a uniform distribution greater than or equal to 0 and less than 1.

Syntax RAND()

Remarks Although RAND does not use arguments, you must supply the empty parentheses to correctly reference the function.

Example RAND()*10 returns a random number greater than or equal to 0 and less than 10.