RAND

Returns the a random number.  The type of random number is determined by the modifier:

Syntax

RAND(modifier)

Arguments

modifier - optional argument to qualify the generation of a random number. By default the function uses 0.

• If modifier < -1 returns integer value between modifier value and -1.
• If modifier >= -1 and modifier < 0 returns negative fractional value between modifier and 0.
• If modifier >= 0 and modifier <= 1 returns fractional value between 0 and modifier.
• If modifier > 1 returns integer values between 1 and modifier.

Example

RAND(-2) could be -1 or -2. RAND() could be any value between 0.0 and 1.0.