Inflation

Returns the current US inflation rate based on the Consumer Price Index (CPI).

Notes

  • Returns the annual inflation rate as a percentage
  • Based on year-over-year CPI change
  • Updated monthly when new CPI data is released
  • Key economic indicator for monetary policy

Common Inflation Ranges

Level Interpretation
< 2% Below Fed target
2-3% Fed target range
3-5% Above target, moderate
> 5% High inflation

Examples

=Inflation()
Current US inflation rate
=Inflation()/100
As decimal for calculations
=1+Inflation()/100
Inflation multiplier

When to Use

  • Real return calculations
  • Portfolio inflation adjustments
  • Economic analysis dashboards
  • Discount rate inputs

When NOT to Use

Scenario Use Instead
CPI index level ConsumerPriceindex()
Core CPI (ex food/energy) ConsumerPriceindexWithoutFoodEnergy()
Energy prices ConsumerPriceindexEnergy()
Food prices ConsumerPriceindexFood()

Common Issues & FAQ

Q: Is this the CPI inflation rate? A: Yes, this returns inflation based on the Consumer Price Index (CPI).

Q: How often is this updated? A: The Bureau of Labor Statistics releases CPI data monthly, typically mid-month for the prior month.

Q: What's the difference between headline and core inflation? A: Headline inflation includes all items. Core inflation (ConsumerPriceindexWithoutFoodEnergy) excludes volatile food and energy prices.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Inflation and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions