General Betting
There is currently 1 person viewing this thread.
I want to generate a random number in P1 if C1 has a value.
I have set up the formula =IF(C1
I have set up the formula =IF(C1
sort by:
Show
per page
Replies: 6
|
By:
The under should work, RAND is a function like IF.
=IF(c1>0,RAND(),0) |
|
By:
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. |
|
By:
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? |
|
By:
Equimine
Where stats show that a number of options have an equal chance of winning, I want a random selection to be made. |
|
By:
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. |
|
By:
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 |