Home → Techniques and Tips → @RISK Distributions → All Articles about RiskMakeInput

3.12. All Articles about RiskMakeInput

Applies to:
@RISK 5.x–7.x

The RiskMakeInput( ) function seems to have a lot of capabilities. Can you give me an overview?

The short answer is: RiskMakeInput lets you treat a formula as though it were an @RISK input distribution. That seemingly simple statement has a lot of implications, which we explore in various Knowledge Base articles:

Combining Inputs in a Sensitivity Tornado
Excluding an Input from the Sensitivity Tornado
Add Your Own Distribution to @RISK
Same Input Appears Twice in Tornado Graph

Special applications:

Alternatives to =IF for Picking Distributions
Replacing RAND with RiskBernoulli or RiskUniform
Event or Operational Risks
Combining Estimates from Several People
Bimodal or Mixed Distribution
RiskSimtable with Distributions as Arguments
Left Skewed or Negative Skewed Log-normal Distribution

Limitations:

"The RiskMakeInput distribution ... may not be correlated." For a partial workaround, see Correlating RiskMakeInput or RiskCompound, Approximately.
"Found invalid formula ... Continue without detecting RiskMakeInput precedents properly?"

Last edited: 2019-02-15

This page was: Helpful | Not Helpful