=CHOOSE(INT(RAND()*4)+1,3,6,8,15)

HTH
--
AP

"mark_varney47"
a écrit dans le message de news:
...

Hi,
Is there a way that I can randomly select one number from a set of two
or more numbers.eg If I wanted to select one number from the set
3,6,8,15.;)


--
mark_varney47
------------------------------------------------------------------------
mark_varney47's Profile:
http://www.excelforum.com/member.php...nfo&userid=333
View this thread: http://www.excelforum.com/showthread...hreadid=561526