New Posts For Thread: Excel help requiredhttps://community.betfair.com/general_betting/go/thread/view/94082/24931881/excel-help-requiredI want to generate a random number in P1 if C1 has a value.I have set up the formula =IF(C1EqimineHave 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.GLhttps://community.betfair.com/general_betting/go/thread/view/94082/24931881/excel-help-required?post_id=450111933#450111933EqimineHave 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.GLTue, 01 Jun 2010 06:00:53 -0500cara,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.https://community.betfair.com/general_betting/go/thread/view/94082/24931881/excel-help-required?post_id=450110957#450110957cara,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.Tue, 01 Jun 2010 05:48:18 -0500EquimineWhere stats show that a number of options have an equal chance of winning, I want a random selection to be made.https://community.betfair.com/general_betting/go/thread/view/94082/24931881/excel-help-required?post_id=450110613#450110613EquimineWhere stats show that a number of options have an equal chance of winning, I want a random selection to be made.Tue, 01 Jun 2010 05:43:23 -0500cara,I can't think how you can stop that happening, unless you set Excel to manual calculation.Why do you need the random number?https://community.betfair.com/general_betting/go/thread/view/94082/24931881/excel-help-required?post_id=450110049#450110049cara,I can't think how you can stop that happening, unless you set Excel to manual calculation.Why do you need the random number?Tue, 01 Jun 2010 05:36:43 -0500Thanks EquimineYes it works but the random numbers still change when Ido 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.https://community.betfair.com/general_betting/go/thread/view/94082/24931881/excel-help-required?post_id=450109525#450109525Thanks EquimineYes it works but the random numbers still change when Ido 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.Tue, 01 Jun 2010 05:30:32 -0500The under should work, RAND is a function like IF.=IF(c1>0,RAND(),0)https://community.betfair.com/general_betting/go/thread/view/94082/24931881/excel-help-required?post_id=450108109#450108109The under should work, RAND is a function like IF.=IF(c1>0,RAND(),0)Tue, 01 Jun 2010 05:09:51 -0500I want to generate a random number in P1 if C1 has a value.I have set up the formula =IF(C1https://community.betfair.com/general_betting/go/thread/view/94082/24931881/excel-help-required?post_id=450106289#450106289I want to generate a random number in P1 if C1 has a value.I have set up the formula =IF(C1Tue, 01 Jun 2010 04:35:26 -0500