Generate Random Numbers

There are two ways to generate random numbers in excel automatically:

1. Use the rand() function. It generates a random number from 0.1 to 0.9. To refresh just use F9. You can use "=round(rand()*100)" to generate whole numbers from 1 to 100. Or if you want, you can also use any other number as the multiplier.
2. Easier still, you can use "=RandBetween(a,b)". Where "a" and "b" are the least and max numbers that you want to generate. For example, if you want to generate a random number from 1 to 100. You will have to use =randbetween(1,100).
   
   Hope this helps!
   
   Happy computing!

Tweet