Excel Guides

Determining a Random Value in Excel

There are a few different ways that you can go about determining a random value in Excel. One way is to use the RAND function. This function will return a random number between 0 and 1. You can then use this number to determine what cell to select or what number to use in a formula. Another way to determine a random value is to use the RANDBETWEEN function. This function will return a random number between the two numbers that you specify. For example, if you wanted to return a random number between 1 and 10, you would use the following formula: =RANDBETWEEN(1,10).

You can also use the CHOOSE function to return a random value from a list of values. For example, if you had a list of names in cells A1:A10 and you wanted to return one of those names at random, you would use the following formula: =CHOOSE(RANDBETWEEN(1,10),A1:A10).

If you want to generate a list of random numbers, you can use the RAND function in conjunction with the ROWS or COLUMNS function. For example, if you wanted to generate a list of 5 random numbers between 1 and 10, you would use the following formula: =RAND()*9+1 (this will generate 5 numbers between 1 and 10).

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.