See also: Growth, GrowthAs, GrowthFromValue, GrowthFromYearXL
GrowthFromYear(Year, GrowthRate) or
GrowthFromYear(Year, GrowthRate, Year2, GrowthRate2) or
GrowthFromYear(Year, GrowthRate, Year2, GrowthRate2, Year3, GrowthRate3)
See also: GrowthFromYearXL(ExcelFile, ExcelRange)
Calculates a value in any given year using a growth rate expression applied after some specified year. Values in earlier years are based on the expression entered in the parent scenario or its ancestor expressions.
GrowthFromYear(2010, 5%, 2020, 3%)
To specify more than three growth rates, use the GrowthFromYearXL function, which works with a table of years and growth rates stored in an Excel spreadsheet.