Random Numbers

For random numbers between 1 to 10

=INT((10 - 1 + 1) * RAND() + 1)

The syntax is =INT((upper limit - lower limit + 1) * RAND() + lower limit)

or

=INT(RAND()*10)+1

This will also return random numbers between 1 and 10. The lower limit is "1". The upper limit is "10". (For random numbers between 5 and 10, try =INT(RAND()*6)+5


© Copyright andrewsexceltips.net All Rights Reserved.