View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dgo
 
Posts: n/a
Default Help with array's


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