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
``````

### Excel

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