Excel Functions in EAC ToolsExcel Functions in EAC Tools\Regulatory limits and other functionsRegulatory limits and other functions\BLS functionsBLS functions\AdjustForInflation

AdjustForInflation

AdjustForInflation returns an inflation adjustment factor based on a beginning year and an ending year. CPI for the year is the average for 12 months in the year. If a year does not have 12 months of CPI data, then CPI for the year is averaged over the number of months that are available.

CPI-U is the Consumer Price Index for All Urban Consumers, and is published monthly on the internet:

·        Inflationdata.com

·        U.S. Bureau of Labor Statistics (U.S. city average, All items - CUUR0000SA0)

Syntax

AdjustForInflation (FromYear, ToYear)

Parameter Name

Description

FromYear

Year: a 4 digit number.

ToYear

Year: a 4 digit number.