help with formula's

New Contributor

I have a sheet with a list of cities populations in two different years. 

I need to get an average increase in the percentage for each one. I was given an answer to the first one. and I am able to do the math manually to get a relatively close answer. I cannot seem to get a formula to work at all... 


c19 is 149855 and d19 is 140275 the answer is supposed to be 6.8% 

I am sure there is a simple way to do this, I have tried everything I know and get nowhere. 

thanks for any advice. 

2 Replies

Here you go...




Thank you! thank you! thank you! I am sure I tried that before too... but it finally worked... I have been fighting this one for 2.5 days...