RAND function

Description

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).

Examples

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.

Calculator

RAND( )

Related functions

• RANDNORM function: returns Normally distributed random numbers
• List of Mathematical functions
• Generate random sample
• Create random groups