Thanks Biff, it works. It's exactly what i was looking for.

"T. Valko" wrote:

One way:

=RANDBETWEEN(1,9)*10+5

--
Biff
Microsoft Excel MVP


"Ram" wrote in message
...
Hi,

I need a formula that will enable me to randomly pick (select) a number
from
the following numbers

15, 25,35,45,55,65,75,85,95

I'm aware of the the RAND & RANDBETWEEN functions and i have not been able
to generate the output as desired.

regards,