Applies to: @RISK 6.x/7.x

Errors:

1. Found invalid formula "..." in "...". Continue without detecting RiskMakeInput precedents properly?
2. The reference "..." in "..." has an OFFSET or INDIRECT, whose precedents cannot be traced. Continue without detecting RiskMakeInput precedents properly

Background:

RiskMakeInput( ) turns any formula into an @RISK input.

During sensitivity analysis, tornado diagrams show sensitivity to the formula as a whole, not to its components or precedent distributions. At the start of a simulation, @RISK identifies distributions used only within a RiskMakeInput( ) so it can exclude them from sensitivity analysis.

If @RISK cannot interpret the formula, it may not correctly identify and exclude those precedents.

Solution:

Change the referenced formula to one that @RISK can interpret.

There is no @RISK setting to ignore RiskMakeInput( ) precedent checking, as there is with Smart Sensitivity Analysis. If you can't change the formula, you'll need to click Yes each time you run a simulation.

Related Articles:

"Found invalid formula ... Continue without Smart Sensitivity Analysis?"

All Articles about RiskMakeInput