Thread: Record Repeats of random function

Good Afternoon everyone.

Again, sorry if the problem has been solved before, but being a new user I couldn't find a solution.
Problem I faced is simple:
I want Excel to record repeats of a random function. Simple example:
I have a function =RANDBETWEEN(1;100) in cell A1 (as an example)
Each time I change something in the table, or press F9, value of the cell changes.

How do I make Excel repeat that function (F9), say 1000 times, and record the result of those repeats (in order to have distribution of these results later on)

Thank you,

Michael

Problem is, that I have just used a simple example to illustrate the issue. Actual problem is about exchange rates, numbers have 7 decimal places, and there are many more than just one.

Fair enough,
Here is attached question.
How do I make Excel record calculation repeats (the ones Excel does when F9 is pressed), of the column 'possible rate'?
I.e. make excel repeat calculations 1000 times and export result to the chart for each currency.

Thank you