Inflation rates for various years

[gchahal]

Hi All,

Newbie here, so please bear with me. I was wondering if anyone has any ideas on how to create a function in excel to calculate the inflation rates of many different years of data all up to 2020. I need to inflate the costs per year all the way upto 2020. Hope this makes sense. Thanks!

2008​

2009​

2010​

2011​

2012​

2013​

2014​

2015​

2016​

2017​

2018​

2019​

2020​

Year

Inflation Rate (%)

2007​

$700.00​

2020​

0.62%​

2009​

$469.45​

2019​

1.95%​

2012​

$562.21​

2018​

2.27%​

2014​

$649.11​

2017​

1.60%​

2017​

$632.11​

2016​

1.43%​

2015​

1.13%​

2014​

1.91%​

2013​

0.94%​

2012​

1.52%​

2011​

2.91%​

2010​

1.78%​

2009​

0.30%​

2008​

2.37%​

2007​

2.14%​

 

[DRSteele]

Welcome to the forum.

This should work. Just put the formula in C2 and copy across then down. Note that I assumed the inflation rate for a year (like 2007) acts on the beginning value of appropriate cell (like $700) for its column (lie 2008). If that isn't the way you want it, we can adjust the formula.

MrExcel posts18.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1			2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020		Year	Inflation Rate (%)
2	2007	$ 700.00	$ 714.98	$ 731.93	$ 734.12	$ 747.19	$ 768.93	$ 780.62	$ 787.96	$ 803.01	$ 812.08	$ 823.69	$ 836.87	$ 855.87	$ 872.56		2020	0.62%
3	2009	$ 469.45		$ 480.58	$ 482.02	$ 490.60	$ 504.87	$ 512.55	$ 517.37	$ 527.25	$ 533.21	$ 540.83	$ 549.48	$ 561.96	$ 572.92		2019	1.95%
4	2012	$ 562.21					$ 578.57	$ 587.36	$ 592.89	$ 604.21	$ 611.04	$ 619.78	$ 629.69	$ 643.99	$ 656.54		2018	2.27%
5	2014	$ 649.11							$ 655.21	$ 667.73	$ 675.27	$ 684.93	$ 695.89	$ 711.68	$ 725.56		2017	1.60%
6	2017	$ 632.11										$ 641.15	$ 651.41	$ 666.19	$ 679.19		2016	1.43%
7																	2015	1.13%
8																	2014	1.91%
9																	2013	0.94%
10																	2012	1.52%
11																	2011	2.91%
12																	2010	1.78%
13																	2009	0.30%
14																	2008	2.37%
15																	2007	2.14%
Sheet62

Cell Formulas
Range	Formula
C2:O6	C2	=IF($A2>C$1,"",(1+INDEX($R$2:$R$15,MATCH(C$1-1,$Q$2:$Q$15,0)))*MAX($B2:B2))

 

[gchahal]

This is amazing and exactly what I was looking for. Thank you so much!!!

 

[DRSteele]

That's good news. Glad to have helped.