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

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)

  • bharker's avatar
    bharker
    Copper Contributor
    Aug 01, 2020
    This is nice! So right now if D5 is yes then B5 is yes, but I need D5, E5, F5, G5, H5, I5 to also all be "yes" for B5 to be yes. If any of D5, E5, F5,H5, or I5 = no, then B5 = no.
    • bharker's avatar
      bharker
      Copper Contributor
      Aug 01, 2020
      Also, nice job on the drop down boxes in column D. Can E,F,G,H, & I also have these same drop downs?
      • bharker's avatar
        bharker
        Copper Contributor
        Aug 01, 2020
        I just figured this one out. I dragged the cells and the formula populated.

Resources