Excel Guides

Random Numbers in a Range in Excel

There are a few ways to generate random numbers in a range in Excel. One way is to use the RANDBETWEEN function. This function takes two arguments, a bottom and top number, and generates a random number between those two numbers. For example, if you wanted to generate a random number between 1 and 10, you would use the following formula:

=RANDBETWEEN(1,10)

Another way to generate random numbers in a range is to use the RAND function. This function generates a random decimal number between 0 and 1. You can then use the following formula to scale this number up to your desired range:

=RAND()*(top-bottom)+bottom

For example, if you wanted to generate a random number between 1 and 10 using the RAND function, you would use the following formula:

=RAND()*(10-1)+1

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.