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 would populate yes. If any of D through I is no or empty then B would be no. Also, is there a formula to have a drop down yes or no box in columns D thru I? Thanks in advance for any input and help!

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

19 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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.
     
    • bharker's avatar
      bharker
      Copper Contributor
      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
        Also, nice job on the drop down boxes in column D. Can E,F,G,H, & I also have these same drop downs?
  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    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
      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