Record Iteration Results

Closed
iuberrys Posts 2 Registration date Monday July 24, 2017 Status Member Last seen July 24, 2017 - Jul 24, 2017 at 03:43 PM
Hello, I have a financial projection spreadsheet that will result in a residual value in a certain cell. I want to run 1000 iterations and record the value of the cell in a column so that I can then look at the distribution of values. I am using a random number generator to mimic investment returns over a 45 year period. Essentially what I want to do is something like:

For X = 1 to 1000
Calc cell A1
Copy A1 to BX (where X goes from 1 to 1000)
Let X = X+1
If X>1000, end

Should be super easy but I just don't know the syntax.