Your A1 formula should be:
=IF(C7=2,S$200,IF(C7=3,S$166,""))
--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"Elynn" wrote:

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...