View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TAB TAB is offline
external usenet poster
 
Posts: 2
Default Simplify formula using quarterly investment returns

Thank you joeu2004 and Dana DeLouis

I have 10 portfolio's that I was calculating returns for. I used the
formula below and it matched my numbers perfectly. This will be a
great time saver going forward. Thanks.

=EXP(4*AVERAGE(LN(1+$H$26:AC26))) - 1 (ctrl-shift-Enter):