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 |
Syntax
=Inflation()Returns
number
Current inflation rate
Examples
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
Is this the CPI inflation rate?
Yes, this returns inflation based on the Consumer Price Index (CPI).
How often is this updated?
The Bureau of Labor Statistics releases CPI data monthly, typically mid-month for the prior month.
What's the difference between headline and core inflation?
Headline inflation includes all items. Core inflation (ConsumerPriceindexWithoutFoodEnergy) excludes volatile food and energy prices.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?