Many users use in-cell formulas to calculate values, on which they perform their analysis. Prism works great with in-cell formulas because it generally references the value of the cell, not the formula that creates it. However, you need to pay attention to TYPE of value your formula returns. For example...