How to Create a Random Number Generator in Excel
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
You might be surprised at how often you need to generate random numbers in Excel.
Maybe it’s for an experiment or some type of hypothetical calculation. Or for whipping up a spreadsheet full of mock data.
No matter the reason, Excel has you covered with two different functions that’ll give you random numbers.
Both RAND and RANDBETWEEN have their unique uses, and we’ll go over both of them here.
Let’s get started!
*This tutorial is for Excel 2019 for Windows. Got a different version? No problem, you can still follow the exact same steps.