Forum Discussion

TR7676's avatar
TR7676
Copper Contributor
Mar 26, 2021

If Yes add value of another cell

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 

excel
Formulas and Functions

3 Replies

Sort By
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Mar 26, 2021

    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.

    • TR7676's avatar
      TR7676
      Copper Contributor
      Mar 26, 2021
      That's it - so simple. Thanks for your help.

Resources