SimulationInterval
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationInterval(Reference Cell, Minimum, Maximum)
Function arguments:
| Reference Cell | Cell to use as source |
| Minimum | (optional) minimum value |
| Maximum | (optional) maximum value |
This function returns the portion of simulation values in a reference cell,
as a percentage, that fell between the Minimum and Maximum values.
If the Minimum value is omitted, the function will return all values
less than or equal to Maxmum. Conversely if Maximum is omitted, the
function will return all values greater than or equal to Minimum.
The function treats Minimum and Maximum as inclusive, meaning it will
return all values >= Minimum, and all values <= `Maximum.
The inverse of this function is SimulationPercentile, which returns a value from the simulation matching a given percentile.