Hi. If v represents the Range A1:A10, then the following two Array Formulas
appear to work ok.
=POWER(PRODUCT(v+1),1/10)-1
=GEOMEAN(v+1)-1
Enter w/ Ctrl+Shift+Enter.
--
HTH. :)
Dana DeLouis
Windows XP, Office 2003
"fronty" wrote in
message ...
I need to calculate the geometric average of returns on stocks.
I looked at the definition of geomean and it will not work for me. I
need to use this formula.
Rgeo={[(1+R1)(1+R2)....(1+Rn)]}^(1/n) -1
Any help would be greatly appreciated.
--
fronty
------------------------------------------------------------------------
fronty's Profile:
http://www.excelforum.com/member.php...o&userid=33530
View this thread: http://www.excelforum.com/showthread...hreadid=533217