Is this formula 100*(PRODUCT(1+C3:N3/100)-1) recognised by Excel

[Chwee Mee]

I've seen the product function being used by with the combination of
calculation and argument eg. 100*(Product(1+C3:N3/100)-1) but it seems like
I've #value! when I update the cells from C3 to N3 or press enter on the cell
with the function. Is this a function need a special add-in file? Please
advise.

[Bob Phillips]

It needs to be array entered, it should be committed with Ctrl-Shift-Enter,
not just Enter.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Chwee Mee" <Chwee Mee@discussions.microsoft.com> wrote in message
news:3121D5E2-A88E-41D1-AC97-0B7A2FCF0799@microsoft.com...
> I've seen the product function being used by with the combination of
> calculation and argument eg. 100*(Product(1+C3:N3/100)-1) but it seems
like
> I've #value! when I update the cells from C3 to N3 or press enter on the
cell
> with the function. Is this a function need a special add-in file? Please
> advise.