Hi Bro/Sis
I created a VBA module to calculate the CAGR value, below is the formula
Function CAGR(EndValue, BeginValue, Years)
CAGR = (EndValue / BeginValue) ^ (1 / Years) - 1
End Function
On my excel sheet, I have the following range Year 1, Year 2 & Year 3. I use the copy and paste function to copy for Year 2 & Year3. By right on Year 2 should have the value =CAGR(N11,$O11,2) and Year 3 should have =CAGR(M11,$O11,3)
Year 1 =CAGR(O11,$O11,1)
Year 2 =CAGR(N11,$O11,1)
Year 3 =CAGR(M11,$O11,1)
May I know is there any function that I can use so that the year can increase when I use copy and paste? Now, i can only get value of 1 on both Year 2 & 3.
Thank you.
I created a VBA module to calculate the CAGR value, below is the formula
Function CAGR(EndValue, BeginValue, Years)
CAGR = (EndValue / BeginValue) ^ (1 / Years) - 1
End Function
On my excel sheet, I have the following range Year 1, Year 2 & Year 3. I use the copy and paste function to copy for Year 2 & Year3. By right on Year 2 should have the value =CAGR(N11,$O11,2) and Year 3 should have =CAGR(M11,$O11,3)
Year 1 =CAGR(O11,$O11,1)
Year 2 =CAGR(N11,$O11,1)
Year 3 =CAGR(M11,$O11,1)
May I know is there any function that I can use so that the year can increase when I use copy and paste? Now, i can only get value of 1 on both Year 2 & 3.
Thank you.
