Applies to: @RISK 8.2 and up

Error:

#VALUE!

 

Error Details:

From @Risk version 8.2 onward, there are more details available to describe what is causing this error message. The error will be from one of four types:

• Missing value - There is a parameter that has not been assigned a value

• Invalid value - Example: The maximum parameter value is smaller than the most likely parameter value

• Invalid Type - Example: Text is used instead of number

• Missing value & Invalid value - There is a parameter that has not been assigned a value AND a parameter is using the wrong data type.

 

Displays of Warnings and Explanations

1. In the Define Distribution Window - There will be a yellow triangle with an exclamation point(!) in it next to the parameter causing the problem. Hovering over this symbol will give the reason that the error is being flagged.

2. In the Model List - The warning symbol will be to the left of the distribution affected.

   • Hovering over will trigger a pop-up display of the explanation(s). 

   • If you have a large number of distributions in the model, there is a button called Issues View at the bottom to filter the ones with issues in them.

3. On the Excel Status Bar - Click on the cell with the #VALUE! error.

   • At the bottom of the Excel window there will be text describing the argument causing the problem and an explanation.

4. In the Results Summary Window - The warning symbol will be to the left of the distribution affected.

   • Hovering over will trigger a pop-up display of the explanation(s).

   • If you have a large number of distributions in the model, there is a button called Issues View at the bottom to filter the ones with issues in them.