Return random numbers
2003-03-18 Other 0 125
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 |