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.