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!