View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chwee Mee
 
Posts: n/a
Default Is this formula 100*(PRODUCT(1+C3:N3/100)-1) recognised by Excel

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.