V
Vince
looking for a function to show compound growth rate of inflation over
different sets of consecutive years
Vince
different sets of consecutive years
Vince
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Myrna Larson
Do you have the CPI data for a series of years? If so, and the percentages for
the last 25 years are in, say, B2:B26, to get the average, use this array
formula
=GEOMEAN(1+B2:B26)-1
Type that formula and hold down CTRL+SHIFT while you press ENTER.
OTOH, if you have the prices of an item in 1975 and in 2000 in A1 and A2,
=(A2/A1)^(1/25)-1
If you are looking for something else, please clarify.
the last 25 years are in, say, B2:B26, to get the average, use this array
formula
=GEOMEAN(1+B2:B26)-1
Type that formula and hold down CTRL+SHIFT while you press ENTER.
OTOH, if you have the prices of an item in 1975 and in 2000 in A1 and A2,
=(A2/A1)^(1/25)-1
If you are looking for something else, please clarify.
F
Fred Smith
Or, if you want to know what the price of something will be given inflation
at x%, use FV:
=FV(#years, x%, current price)
at x%, use FV:
=FV(#years, x%, current price)
V
Vince
Myrna Larson said:Do you have the CPI data for a series of years? If so, and the percentages for
the last 25 years are in, say, B2:B26, to get the average, use this array
formula
=GEOMEAN(1+B2:B26)-1
Type that formula and hold down CTRL+SHIFT while you press ENTER.
OTOH, if you have the prices of an item in 1975 and in 2000 in A1 and A2,
=(A2/A1)^(1/25)-1
If you are looking for something else, please clarify.
Myrna,
The latter was the perfect formula. Thanks
Vince