How To Generate A Random Number In Excel

Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to for professional help and Excel Tutorials

It’s a rather simple task but one that we often need to perform; being able to generate a random number. There are 2 different ways to get this done in excel.

#1-For a simple request such as: “Give me a number between 1 and 10”?

You can simply use the function randbetween:


Then, anytime you want to generate a new number, you’d press “F9” on your keyboard (refresh)

#2-If you’re looking for something a bit more sophisticated, you could use the function “rand” which would give you a number between 0 and 1 with (decimals)

So if i was looking at a number between 1 and 10 but wanted to include decimals I could do:


Simple enough?


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss



Please Leave a Comment!

Please note: Comments may be moderated. It may take a while for them to show on the page.