RAND (Primitive Spread Function) returns an evenly distributed random number greater than or equal to 0 and less than 1. The RAND function returns a new random number every time the sheet is calculated.

SYNTAX:

RAND()

REMARKS:

This function does not accept arguments.

To generate a random real number between x and y, with y greater than x, use the following expression:

RAND()*(y-x)+x

To generate a random integer between x and y, with y greater than x, use the following expression:

int((y-x+1)*RAND()+x) 

EXAMPLES:

RAND()
RAND()*100
int(RAND()*100)