Life can be random; so can Excel. Looking for some winning Powerball numbers? Random number generator Excel functions might be able to deliver. If you’re not a gambler there are lots of other reasons you may want some random numbers. Maybe you’re doing statistical sampling, computer simulation or even cryptography (all uses according to Wikipedia .) Whatever the reason, the random number generator Excel functions are simple to use. You just need to decide how random you want to be:
Get a Number Between 0 and 1 with the RAND() Function
Just type RAND() into any cell:
Don’t like the number? Not a problem! You can get a new one. Just:
- click on the cell with your random number
- click on the formula bar
- click on any cell
Presto, new number.
If you want a string of random numbers, just use autofill (select the random number cell and drag the little black box on on the lower right side downward). Get as many as you want:
The results are in decimal form, which you can easily reformat to the decimal length of your choice or a percentage.
Get a Number Between Two Specific Numbers with the RANDBETWEEN(Bottom, Top) Function
Maybe you want a random number, but not that random. Have no fear! There’s a random number generator Excel function for you.
Just type RANDBETWEEN(your bottom number, your top number) in any cell. In this example I use 1 and 15:
There you have it! The random number generator Excel functions are quick and easy to use. I hope this was helpful, and if you do end up with the winning lottery numbers via this tip don’t forget where you got it!
I’d love to hear why you’re looking to generate random numbers – let me know below!
Want more Excel tips? Here you can learn how to multiply in Excel.