Help with array's

D

dgo

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
:) :)
 
B

Bob Phillips

=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)
 
Top