I am trying to do a Monte Carlo simulation using Excel, but a lot of the tutorials I have found are either for older versions of the product, or are not quite what I am after. A simple example of the kind of think I am after is:

Cell A1 contains the formula to simulate (for example int(6*rand())+1 to simulate rolling a dice).

I have 10 rows of "Trials". What I want is to somehow point each row at a different calculation of the formula in A1. So I would end up with something like

Trial   Value 
1       2
2       5
3       6
4       2
5       1
6       3
7       2
8       4
9       2
10      1

I have tried playing with some of the "What-if Analysis" tools, but I am a bit lost.