fx formula help cost multiplied by 8% each year

[QTQ28]

Ok so i need the current estimate to show: what the current cost/sq would be now if you added 8% increase to the cost/sq determined in the inspection year. Does that make sense? In the example below, there are 9 years between 2015 and 2024, so 9 x .08 = .72. If I then multiply 266 by 1.72, i get the desired number of 457.52. But how do i put that into a formula that excel will calculate on it's own? Thank you!

Cost/Sq	Style	Yr Blt	Inspected Year	Current Year	Current Est
266​	Mediterrenean	1993​	2015​	2024​

 

[saboh12617]

Hello,
Is this formula be acceptable?

=(1+0,08*(CurrentYear-InspectedYear))*CostSq

 

[QTQ28]

thanks for your help! If I do this:

= (1+0,08*(J2-I2))*F2 i get an error

 

[Fluff]

Replace the comma with a period.

 

[QTQ28]

Ahhhhh thank you so much Excel wizard friends!!!

 

[Fluff]

Glad we could help & thanks for the feedback.