Multiply/Sum cells containing formulas

[Elynn]

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

 

[John]

Hi Elynn
In A1 it should be like this:=IF(C7=2,"S$200",IF(C7=3,"S$166"))
in A2 you would like to multiply A1 with F4 "I think" but A1 is considered
text "S$200" and f4 don't know ?
You would need to elaborate on the function Product in A2
Regards
John

 

[porter444]

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]

Thanks Both

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