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

Multiply/Sum cells containing formulas
 

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
"Elynn" wrote in message
...
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...

Multiply/Sum cells containing formulas
 

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

Multiply/Sum cells containing formulas
 

Thanks Both

"porter444" wrote:

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