GrowthFromYearXL

See also: Growth, GrowthAs, GrowthFromValue, GrowthFromYear

Syntaxes

GrowthFromYearXL(ExcelFile, ExcelRange)

See also: Using Time-Series Functions and Specifying Excel File and Range Parameters.
 

Description

Calculates a value in any given year using growth rate expressions stored in the named Excel filename and range. Values in earlier years are based on the expression entered in the parent scenario or its ancestor expressions.

Example

GrowthFromYearXL(C:\grow.xls, GrowRange)
GrowthFromYearXL(C:\grow.xls, Sheet1!B2:C27)