Show menu

RAND function


Random number function (uniform distribution). RAND(x) returns a computer-generated random number:

(a) when x < 1 then the result is a number between 0 and 1, or

(b) when x > 1 then the result is a whole number between 1 and x (inclusive).


RAND(10) can return 4 or any other whole number ranging from 1 to 10.

RAND(1) can return 0.8755 or any other number between 0 and 1.



Related functions

Share on Facebook Share on Twitter

This site uses cookies to store information on your computer. More info...