Fill a table from a RAND based formula in Excel 2010
- by Greg Reynolds
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…