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