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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My Excel 2007 won't multiply. (ex. =C3*D3 enter) ... nothing ! 2
Calculating the value of a cell from another cell 2
QP formulas not working in Excel 2
EQUIVALENT for this FORMULA , please 1
Setting a cell with a value as a reference for another function 1
A function to get a variable row reference for range in XNPV funct 6
Copy Excel functions formula and auto refresh refresh 3
Excell Formula copying-to-stay the same. 1

Back
Top