Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert & multiply (number & time)formulas | Excel Worksheet Functions | |||
Paste Special - Formulas - Multiply | Excel Discussion (Misc queries) | |||
HOW TO MULTIPLY 2 CELLS THAT CONTAIN FORMULAS | Excel Discussion (Misc queries) | |||
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% | Excel Discussion (Misc queries) | |||
Formulas do not multiply when filled down | Excel Worksheet Functions |