View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fronty
 
Posts: n/a
Default How do I type this so excel recognizes it?


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