"srinivasan" wrote:

Can any one suggest a formula/code to work out the CAGR(Compounded Annual
Growth Rate)

I am sorry. The rate function will not work for this. The formula for the
function would look like this.
=(J7/F7)^(1/4 )-1 (NUMBER 4 REPRESENTS FOR the count of columns from J
column to F column excluding J column)
I would be happy if some one suggests a custom code for a formula named CAGR