If Yes add value of another cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2237600%22%20slang%3D%22en-US%22%3EIf%20Yes%20add%20value%20of%20another%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2237600%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20why%20I'm%20struggling%20so%20much%20with%20this%20formula.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20%22cell%20A%22%20to%20replicate%20the%20value%20of%20%22cell%20B%22%20If%20%22cell%20C%22%20(dropdown%20Yes%20%26amp%3B%20No%20cell)%20is%20Yes%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20help%20in%20advance%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2237600%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi All, 

 

I'm not sure why I'm struggling so much with this formula. 

 

I need "cell A" to replicate the value of "cell B" If "cell C" (dropdown Yes & No cell) is Yes

 

Thanks for your help in advance 

3 Replies

@TR7676 

For example in A2:

 

=IF(C2="Yes",B2,"")

@TR7676 

 

Here is a small example in the attached file.

=IF(C1="Yes",B1,"")

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

That's it - so simple. Thanks for your help.