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!