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):
|