Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel for Calculating a CAGR
Thanks for eveyone's help. I wound up using the following formula: =IF(K3>=L3,"nm",IF(K3<$B$1,"nm",IF(K3>I$1,"nm",IF(L3<$B$1,"nm",IF(L3>I$1,"nm",((HLOOKUP(L3,$B$1:$I$199,ROW(),FALSE)/HLOOKUP(K3,$B$1:$I$100,ROW(),FALSE))^(1/(L3-K3))-1))))))...- michels24
- Post #5
- Forum: Microsoft: Office
-
Excel for Calculating a CAGR
Hi, I am setting up a formula so Excel will calculate the CAGR (defined as: (end number/begin number)^(1/(end year-begin year))-1. The Excel sheet has the years (1999 to 2006) running fixed across the top in columns b to i. The concept is that someone will enter the begin year and end year into...- michels24
- Thread
- Replies: 4
- Forum: Microsoft: Office
