Originally Posted by Milhouse
How random is rand() and how good are the distribution functions in excel?
Rand() is purely random for numbers between 0 and 1. You can also force it to return random values between two set values (say, 1 and 100), however it will never choose the top value of the range (in this case, 100. It'll return up to 99.999999999999).
Here's a website that details choosing a random number between two given...