Formula Functions > Functions R to S > RAND |
This function returns an evenly distributed random number between 0 and 1.
RAND()
This function does not accept arguments.
This function returns a new random number.
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)
This is a volatile function with version 2.5 or later. For more information, refer to Volatile Functions.
Does not accept data. Returns numeric data.
RAND()
RAND()*100
INT(RAND()*100)
This function is available in product version 1.0 or later. This function is a volatile function in version 2.5 or later.
RANDBETWEEN | INT | Math and Trigonometry Functions