Hi. Suppose your first three data values are in A1:A3.
In B3, enter this array formula:

=GEOMEAN($A$1:A3+1)-1 (Ctrl+Shift+Enter)

As you add data in Column A, Drag B3 Down.

--
HTH :)
Dana DeLouis
Windows XP & Excel 2007


"TAB" wrote in message
ups.com...
I need some assistance in simplifying a formula that calculates the
annualized return using quarterly returns. I have a spreadsheet that
I have calculated the quarterly returns on my investment account for
the past 7 years. To get an annualized return for the past 7 years
(and going forward) my formula looks like this with the letters
representing quarterly returns.

((a%+1)*(b%+1)*(c%+1)........)^(1/(# of quarters)-1

So each quarter I have to add another quarter of data to the formula
which get tedious when doing it on several investment portfolios.

Is there a simpler way of doing this? An array which takes care of
the (a%+1)*(b%+1) etc... formula that I can keep copying each quarter.

I do calculate the 3yr and 5yr returns also but those formulas stay
the same with 3 years having 12 quarterly returns and 5yr having 20
quarterly returns each