trouble with a growth rate

[Larry Holt]

I am tring to calculate a city's Compound growth rate, but I keep
getting an error. the city has 233,149 as of 2004, and 242,820 in 2000.
My formula is =(D4/J4)^(1/(2004 -2000))-1
Thanks for any help.

 

[Guest]

I'm getting 1%, assuming that D4 contains 242,820 and J4 contains 233,149

That looks about right

 

[Daniel CHEN]

I am getting +1.0212%.
For growth rate, the 2000 value should be less than 2004 value, right?
You can also use rate function.

--
Best regards,
---
Yongjun CHEN
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download

=================================

 

[Larry Holt]

I am getting +1.0212%.
For growth rate, the 2000 value should be less than 2004 value, right?
You can also use rate function.

That may be my problem-the 2000 pop is more than the 2004.
lhs

 

[Fred Smith]

Even though the population has decreased, you can still calculate the growth
rate. It's just negative. You might find it easier (for both you and anyone
looking at the spreadsheet later on) to use the Rate function.