If Yes add value of another cell

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