Hello,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I am hoping that someone can help with a problem. I need to generate random numbers in Excel 2003 within a defined set of probabilities:
30% of numbers between 1,501 and 2000
40% of numbers between 1,000 and 1,500
30% of numbers between 100 and 1,000
<o> </o>
My attempts so far have been:
In cell A1: Rand()
In Cell A2: =IF(+A1>.7, =randbetween(100,1000), IF(+A1>.3, =randbetween(1001,1500), IF(+A1>0, =randbetween(1501,2000))))
<o> </o>
Excel 2003 generates syntax errors for the formula in A2. I have also tried:
In cell A1: Rand()
In Cell A2: =IF(+A1>.7, =randbetween(100,1000, IF(+A1>.3, =randbetween(1001,1500, IF(+A1>0, =randbetween(1501,2000)))
<o> </o>
That also generates syntax errors.
<o> </o>
It looks like it isn’t possible to embed Randbetween() statements into an IF statement within Excel 2003. By now you have probably guessed that I am new to this. Is anyone able to suggest a solution?
<o> </o>
Regards,
stevech
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
I am hoping that someone can help with a problem. I need to generate random numbers in Excel 2003 within a defined set of probabilities:
30% of numbers between 1,501 and 2000
40% of numbers between 1,000 and 1,500
30% of numbers between 100 and 1,000
<o> </o>
My attempts so far have been:
In cell A1: Rand()
In Cell A2: =IF(+A1>.7, =randbetween(100,1000), IF(+A1>.3, =randbetween(1001,1500), IF(+A1>0, =randbetween(1501,2000))))
<o> </o>
Excel 2003 generates syntax errors for the formula in A2. I have also tried:
In cell A1: Rand()
In Cell A2: =IF(+A1>.7, =randbetween(100,1000, IF(+A1>.3, =randbetween(1001,1500, IF(+A1>0, =randbetween(1501,2000)))
<o> </o>
That also generates syntax errors.
<o> </o>
It looks like it isn’t possible to embed Randbetween() statements into an IF statement within Excel 2003. By now you have probably guessed that I am new to this. Is anyone able to suggest a solution?
<o> </o>
Regards,
stevech