Hi. I'm using =rand( for the data and setting it to 3 decimal place. As you know anytime you click, input, etc. in any cell, the =rand( automatically changes.
I want a macro, where I can continuously have it input something (i.e. in column D it just keep inputting "1 Enter") so it keeps changing my
data set until it reaches a certain number - let's say 0.001
based on the result in row 4, I want the macro to keep inputting 1 until one of those 3 values reaches STOP (indicating .001)
Any help/solution is much appreciated
<tbody>
</tbody>
I want a macro, where I can continuously have it input something (i.e. in column D it just keep inputting "1 Enter") so it keeps changing my
data set until it reaches a certain number - let's say 0.001
based on the result in row 4, I want the macro to keep inputting 1 until one of those 3 values reaches STOP (indicating .001)
Any help/solution is much appreciated
0.552 | 0.252 | 0.134 | 1 | |
1 | ||||
=if(a2=.001,stop,go) | =if(b2=.001,stop,go) | if(c2=.001,stop,go) | 1 | |
1 |
<tbody>
</tbody>