Excel Random number from a set of options

excel, excel-formula

Solution

This formula will do it:

=CHOOSE(RANDBETWEEN(1,5),15,30,50,75,100)

If you want to use a range of cells:

=INDEX($B$2:$B$6,RANDBETWEEN(1,5))

Problem

In MS Excel, how can I randomly calculate a number number that is from one of a set of 5 options? For example, in cell B1 I would like to have a random number that is either 15,30,50,75, or 100. I would like a completely random output of these 5 numbers in cells B1:B100. I was thinking that I could generate a random number in cell A1 using rand, then using a series of > or < IF statements to output only one of these numbers above.

Original source