View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elynn Elynn is offline
external usenet poster
 
Posts: 5
Default Multiply/Sum cells containing formulas

Hi there,
I need help to performing product on cells containing formulas / hyperlink.
Example on a cell A1=IF((C7=2,"S$200"),IF(C7=3,"S$166")) and in cell
F4=sum(B1:B3) and A2=Product(A1,F4).
Currently, I have error...