Patrickwest
09-21-2016, 06:07 PM
I am facing a problem with RANDBETWEEN. I would appreciate if someone could help.
In the Cell B2, I keyed in a formula IF(A2=1,1,""). In the Cell C2, I keyed in the formula IF(B2=1,RANDBETWEEN(0,9),"").
When I key in the no.1 in the Cell A2, everything works fine.
Then, I fill down Cells A2, B2 and C2 all the way to A10, B10 and C10.
When I key in the no.1 in the Cell A10, the number in C2 changes and changes each time I key in a value regardless of whether no.1 or not.
Need not necessarily I key in either of Cells A2 to Cells A10, even if I key in Cell K222, the number in the Cell C2 still changes.
I do not want the value in Cell C2 or C10 or any other Cells to change for any reason after the first number is shown.
I do not know how to solve this problem.
Is there any VBA macro I need to create to solve this problem? I do not know anything about VBAs.
Thanks.
In the Cell B2, I keyed in a formula IF(A2=1,1,""). In the Cell C2, I keyed in the formula IF(B2=1,RANDBETWEEN(0,9),"").
When I key in the no.1 in the Cell A2, everything works fine.
Then, I fill down Cells A2, B2 and C2 all the way to A10, B10 and C10.
When I key in the no.1 in the Cell A10, the number in C2 changes and changes each time I key in a value regardless of whether no.1 or not.
Need not necessarily I key in either of Cells A2 to Cells A10, even if I key in Cell K222, the number in the Cell C2 still changes.
I do not want the value in Cell C2 or C10 or any other Cells to change for any reason after the first number is shown.
I do not know how to solve this problem.
Is there any VBA macro I need to create to solve this problem? I do not know anything about VBAs.
Thanks.