Skip to main content

Hi all,


I’m working on figuring out how to accurately show a compound annual growth rate. Using the power function gets me close but I can’t seem to reflect a full percentage. Here’s an example:


POWER(TTM/2014,1/5)-1


That works for raising calculating 1/100th of the accurate annual percentage growth over 5 years. Any thoughts on how to raise it to be a fully accurate percentage?


Thanks!

Turns out I was able to answer my own question with some experimenting. To get CAGR, use this formula:


POWER(End Period/{Start Period},1/Time)*100-100


For me it looked like this:


POWER(TTM/{2014},1/5)*100-100


Looking forward to doing a lot more with Airtable!


Tim

Reply


Terms & Conditions