SimulationValue
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationValue(Reference Cell, Trial number)
Function arguments:
| Reference Cell | Cell to use as source |
| Trial number | The trial number to return |
Returns one value from the simulation, from the specified cell. Trial numbers are 1-based (so the first trial is 1).
Example
If you want to see all values from the simulation,
use SimulationValuesArray — it will be much faster than using lots
of SimulationValue functions.