Jacob's formula is perfect; since you have more data points than indicated in
your original post, you need to edit the range in the formula to match your
data:

=SUMPRODUCT(PRODUCT(B2:B13+1))-1

Putting your actual returns in B2:B13, I got the same result you did by
computing it manually and by using the above formula.

Hope this helps,

Hutch

"txsharla" wrote:

Thanks, Jacob, but that's not quite right. Here are the actual returns:

-1.78%
0.48%
1.60%
-0.68%
-1.86%
-1.53%
-8.59%
-6.56%
-2.19%
-2.08%
1.03%
0.08%

The answer is -20.39% (doing it longhand). Any other ideas?

"Jacob Skaria" wrote:

Try
=SUMPRODUCT(PRODUCT(B2:B5+1))-1

If this post helps click Yes
---------------
Jacob Skaria


"txsharla" wrote:

I want to mathmatically link a column of monthly returns (percentages) like
this:

(1+b2)*(1+b3)*(1+b4)*(1+b5)-1 (where b2=3.05%, b3=2.54% etc...)

I know there are other ways of doing this longhand but I'm looking for the
formula to simpifly my work. Thanks!