SampleValue
RiskAMP Random Distribution Functions
Using this function in Excel:
=SampleValue(Data, Replacement)
Function arguments:
| Data | Range of values to sample |
| Replacement | Set TRUE to use replacement |
Returns one value from a list of values, with or without replacement.
When Replacement is set to FALSE, if the number of trials is greater
than the number of values, this function will sample each value once and
then start again (in a different random order).