Is there an excel formula for compound average rate?

by on January 17, 2012

Q: Is there an excel formula for compound average rate?

example:
2009 – $25,000
2010 – $32,000
2011- $36,000

what is the compound average rate for the 3 years?


One Response to “Is there an excel formula for compound average rate?”
  1.  

    I am not sure if you mean “compound average” or just “average”. I am not sure what the “compound average” would even mean in this case to be honest.

    To get the average you would just do =SUM(A1:A3)/COUNT(A1:A3) which just translates into adding up the 3 cells and then dividing by the count of the 3 cells (or you could just divide by 3 since you know the number of cells).