CB.GetAssumPercent

This function calculates the value of the specified assumption that corresponds to the specified percentile. You can call this function from either a subroutine or a worksheet. To call this function from a worksheet, use the name CB.GetAssumPercentFN.

Note:

In VBA code, always call CB.CheckData before calling this function to ensure the latest data values are used.

Table 87. CB.GetAssumPercent Returned Data Type

Returned Value	Returned Data Type
Assumption value that corresponds to the specified percentile	Variant

The percentile is calculated based on the assumption’s distribution. Any truncation points are factored into the percentile calculation.

Note:

Reversing the percentiles using the cbRunReversePercentile option does not affect the output of this function. For more information, see CB.RunPrefsND.

Table 88. CB.GetAssumPercent Parameters

Parameter	VBA Data Type	Value	Description
AssumReference	Variant	In a macro: Range("B3") In a worksheet: B3	Points to the desired assumption cell
Percent	Double	A number between 0 and 100	Specifies the percentile for which you want the assumption value

Parameter

VBA Data Type

Value

Description

AssumReference

Variant

In a macro: Range("B3")

In a worksheet: B3

Points to the desired assumption cell

Percent

Double

A number between 0 and 100

Specifies the percentile for which you want the assumption value