Return random numbers

 2003-03-18    Other    0    53

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


Leave a comment:

Your comment will only be published after it has been moderated and found spam free.
Your e-mail address will only be used to display your Gravatar.