This example, before a simulation, displays 0 in the cell. After a simulation, it displays the standard deviation of the forecast in B7.
In a worksheet cell, you can enter:
=CB.GetForeStatFN(B7,5)
Note: | You must use the numeric value of the Index parameter in a worksheet cell. The named constant will not work. |