How do I select a number from a specific group of numbers?

[motol]

I need to randomly select one of the numbers out of the following
group: 1, 5, 7, 8.

Is there a formula I can use?

 

[Sandy Mann]

try:

=--CHOOSE(INT(RAND()*4)+1,"1","5","7","8")

--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk

 

[motol]

Works perfectly! Thanks!