This function calculates the value of the specified forecast that corresponds to the specified percentile. You can call this function from either a macro or a worksheet.
Note: | To call this function from a worksheet, use the name CB.GetForePercentFN. |
Table 121. CB.GetForePercent Returned Data Type
Returned Value | Returned Data Type |
|---|
Forecast value that corresponds to the specified percentile | Variant |
You must run a simulation before you call this function, or it returns 0.
Note: | Reversing the percentiles using the cbRunReversePercentile constant does not affect the output of this function. For more information, see CB.RunPrefsND. |
Table 122. CB.GetForePercent Parameters
Parameter | VBA Data Type | Value | Description |
|---|
ForeReference | Variant | In a macro: Range("B3") In a worksheet: B3 | Points to the forecast cell for which you want the percentile value |
Percent | Double | A number between 0 and 100 | Specifies the percentile for which you want the forecast value |