Hi,

I have a list of monthly returns in Excel going in dowin in one column.
Rather than writing a formula to find the cumulative return over 1.5
years by doing =((1+A1/100)*(1+A2/100)-1)*100 etc I have used a formual
before which I think was an array. Can anybody help please?

Thanks
:) :)


--
dgo
------------------------------------------------------------------------
dgo's Profile: http://www.excelforum.com/member.php...o&userid=35854
View this thread: http://www.excelforum.com/showthread...hreadid=556457

=PRODUCT(1+A1:A100/100)

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"dgo" wrote in message
...

Hi,

I have a list of monthly returns in Excel going in dowin in one column.
Rather than writing a formula to find the cumulative return over 1.5
years by doing =((1+A1/100)*(1+A2/100)-1)*100 etc I have used a formual
before which I think was an array. Can anybody help please?

Thanks
:) :)


--
dgo
------------------------------------------------------------------------
dgo's Profile:
http://www.excelforum.com/member.php...o&userid=35854
View this thread: http://www.excelforum.com/showthread...hreadid=556457

Thanks Bob!


--
dgo
------------------------------------------------------------------------
dgo's Profile: http://www.excelforum.com/member.php...o&userid=35854
View this thread: http://www.excelforum.com/showthread...hreadid=556457