I have developed a formula to generate a random number between 0 and 1, (RAND
()). I take the product and apply some additional calculations. At a later
step, (step 4) I want the program to automatically regenerate a new random
number if a condition has not been met, (in my case, if W is 1). Nothing I
try seems to work. I always get hung up on the automatic part. Any ideas?
Thank you very much.