srichelieu
New Member
- Joined
- Mar 28, 2005
- Messages
- 8
Hello,
I am trying to figure out how to have excel randomly return a value in a cell from a specific set of numbers...
basically i would like for excel to randomly enter a 30, 60, 90, 120, 150, 180, 210, 240, 270, or 300 value in a series of cells (say a1 through a 400). In addition, once it is done the first time, I don't want it to change again.
during a web search I saw the suggestion for something like this:
=CHOOSE(INT(RAND()*4)+1,3,6,8,15)
but this didn't work and gave me a #Value error
any help is much appreciated
Steph
I am trying to figure out how to have excel randomly return a value in a cell from a specific set of numbers...
basically i would like for excel to randomly enter a 30, 60, 90, 120, 150, 180, 210, 240, 270, or 300 value in a series of cells (say a1 through a 400). In addition, once it is done the first time, I don't want it to change again.
during a web search I saw the suggestion for something like this:
=CHOOSE(INT(RAND()*4)+1,3,6,8,15)
but this didn't work and gave me a #Value error
any help is much appreciated
Steph