Forum Discussion
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!
- 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)
19 Replies
- NikolinoDEGold ContributorI'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)
- bharkerCopper ContributorThis 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.
- bharkerCopper ContributorAlso, nice job on the drop down boxes in column D. Can E,F,G,H, & I also have these same drop downs?
- NikolinoDEGold Contributorsry 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 🙂
- bharkerCopper ContributorThanks 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.
- Ramiladevendra1952Copper ContributorI can not add Maps in the ribbon , Even Ideas not work