Return random numbers

 2003-03-18    Other    0    58

The worksheetfunction RAND() will return a decimal value greater than or equal to 0 and less than 1. Here are some examples on how to use this function :

=RAND()*100 Returns a decimal value between 0 and 100
=RAND()*(100-50)+50 Returns a decimal value between 50 and 100
=ROUND(RAND()*100,0) Returns an integer value between 0 and 100