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
- Enter your list of percentages in a column in Excel.
- In an adjacent cell, use the formula
Formula:
=RANDBETWEEN(1,891)
to generate a random number between 1 and 891. - 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.