How To Generate A Random Number In Excel

Excel function 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