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: