Using Rand() function to randomly select a percentage from a list

Yes, you can use the function in Excel to randomly select a percentage from a list. However, the formula will only give you a random number between 0 and 0.1.

Steps to randomly select a percentage from a list of 891

1. Enter your list of percentages in a column in Excel.
2. In an adjacent cell, use the formula
   Formula:

   =RANDBETWEEN(1,891) 

   to generate a random number between 1 and 891.
3. In another cell, use the formula
   Formula:

   =INDEX(A:A, [random number cell]) 

   to return the percentage corresponding to the randomly generated number.

For example, if your list of percentages is in column A and you generate a random number in cell B1 using the formula, you can use the formula in cell C1 to return the randomly selected percentage.