Forum Discussion

bharker's avatar
bharker
Copper Contributor
Aug 01, 2020
Solved

Need assistance with formulas

Hello all, I needed some assistance with some formulas. Looking for column B starting @ B5 to auto populate with a yes or no depending on the answers in columns D thru I. If they are all yes, then B...
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Aug 01, 2020

    bharker 

    I'm not sure because the translation is not the best ... but here is an example.

    Have a dro down menu built in D, at the same time the formula is built in B.
     
     

    If you find this helpful, please mark it as Like (click thumbs up) and as "Best Answer", it will be beneficial to more Community members reading here.

     

    Nikolino

    I know I don't know anything (Socrates)

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Aug 01, 2020
sry but i didn't understand the task. If D is yes or no, you want it to appear in B. If I is no and D yes, then what in B? ... Please repeat the task, as simple as possible, so even beginners as I can understand it 🙂
bharker's avatar
bharker
Copper Contributor
Aug 01, 2020
Thanks for the reply. If anything in D thru I is not a "yes", then B will be a "no" . If D thru I are all yes, then B is yes.

Resources