Use Excel To Generate Random Numbers
Sep 8th, 2009 Posted in Excel Tips | no comment »
Whether you’re playing the lottery or need to randomly select the winner of a contest, you can use Excel to generate a random number.
Let’s say, we wanted to calculate a random number between 4 and 75. The Excel formula is =rand()*(75-4)+4. To calculate a random number between 1 and 100: =rand()*(100-1)+1.
Didn’t know Excel could do this didja?
