Palisade Knowledge Base

HomeTechniques and Tips@RISK DistributionsCell References with RiskCompound

3.51. Cell References with RiskCompound

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

When creating a RiskCompound function, I notice that the results are the same if the entire distribution is defined within the function or if one of the component distributions is defined in another cell that the RiskCompound function references. However, if the function references another cell which references a third cell, the results are different.

The RiskCompound function is not designed to work the same with references to references as it does with a single cell reference. Please see the attached worksheet for a complete explanation.

See also: All Articles about RiskCompound

Last edited: 2021-11-18


This page was: Helpful | Not Helpful