Forum Discussion
Need assistance with formulas
- 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.
- Brilliant! You saved my day!
Du hast meinen Tag gerettet!bharker Looks like NikolinoDE provided the exact solution you wanted.
However, being a past property manager, myself, I couldn't help but notice a minor issue. Your column G is labeled "Equipment/Repairs Needed?" Putting a "Yes" in this column would seem contrary to having a unit "Rent Ready."
My first thought was to change the column heading to "Equipment/Repairs Completed" so as to be consistent with other columns and require a "Yes" to get a "Yes" in column B. However, entries in G like "woodwork" or "A/C broken" might then be misconstrued as repairs completed - rather than as repairs required.
Alternatively, you could change the formula in B to require a "No" in G and a "Yes" in the others. Here is the modified formula:
=IF(AND(D5="Yes",E5="Yes",F5="Yes",G5="No",H5="Yes",I5="Yes"),"Yes", "No")
Whichever way is less confusing is up to you, of course. Personally, I'd think requiring "Yes" in all columns makes more sense. While not a direct reply to your question, I hope you find my comments helpful. ~RonR
Yes, I caught that as well once I started filling it out. Is there a way if B is yes to have the cell highlighted green, and if no highlighted in red?
