Excel If Formula Doubt

[joaoortinsbrito]

Hi,


Im stuck in an if question.


I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I want it to SUM the number in the first column and a number in the second column associated with the word "yes".


Is it possible?


For example the sum with 7(first column) with 5 (second column associated to "yes") which will give 12 in the third column.


Thanks a lot

 

[FDibbins]

Im a bit confused but maybe this?

=A1+if(B1="yes",5,0)

 

[joaoortinsbrito]

Keeps appearing me this

 

[Scott Huish]

=A1+(5*(B1="yes"))

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="text-align:right; ">7</td><td >yes</td><td style="text-align:right; ">12</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C1</td><td >=A1+(5*<span style=' color:008000; '>(B1="yes")</span>)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span>

 

[joaoortinsbrito]

Imgur: The most awesome images on the Internet

Keeps appearing me this

 

[Scott Huish]

Do you need ; instead of , in your formulas perhaps??

 

[joaoortinsbrito]

you're the man.

Thanks a lot

 

[FDibbins]

Then with ; instead of , mine will probably work too