Excel help required

The under should work, RAND is a function like IF.

=IF(c1>0,RAND(),0)

Thanks Equimine

Yes it works but the random numbers still change when I
do something else on the worksheet.

Sorry about posting twice, not having used the forum for along time I thought all the question was not put up.

cara,

I can't think how you can stop that happening, unless you set Excel to manual calculation.
Why do you need the random number?

Equimine

Where stats show that a number of options have an equal chance of winning, I want a random selection to be made.

cara,

I might be barking totally up the wrong tree, are you looking at some sort of Monte Carlo simulation.
If so on Excel help (2007 version anyway) type in Monte Carlo and it should give you a link that might prove helpful.

Eqimine

Have decided to generate the numbers on a separate sheet all at the same time so that the change of number will now not happen.

Many thanks for taking the time and trouble to reply.

GL