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:
=RANDBETWEEN(1,10)
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:
=10*rand()
Simple enough?
***************************************************
Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss
***************************************************
