@RISK Error: #VALUE Errors in Corrected Correlation Matrix
Applies to: @RISK 5.5 and Up RiskCorrectCorrmat( ) Error: #VALUE Cause: If your original correlation matrix or adjustment-weights matrix includes values both above and below the diagonal, it must be symmetric. Otherwise, the RiskCorrectCorrmat( ) array function will return #VALUE in all cells. Solution: To avoid this problem, make sure the original correlation matrix and the adjustment weights matrix have values on one side of the diagonal. NOTE: When you create a correlation matrix in @RISK's Define Correlations dialog and ask @RISK to write the matrix to Excel, you will see that @RISK won't write any values above the diagonal. Related Article: How @RISK Adjusts an Invalid Correlation Matrix