Forum Discussion
Help with Data Validation of Min and Max with Overlap Yes/No
Hello, I have difficulty creating a data validation set. How do I create one column that automatically answers "yes" or "no" (I am assuming something similar to True/False) by itself using the va...
Since you've already gone to the trouble of creating the spreadsheet, unless it has proprietary information in it, it would be a LOT easier to help you if you attached the spreadsheet itself. I'm going to suggest a formula that should work, but with the actual, we could test it.
IF(AND(N8>$N$4,O8<$O$4),"Yes","No")
Copy that down to succeeding rows. You can surround it with other conditions for blank rows....
For future reference, though, when you ask for help, you help us help you by posting the sheet itself, not just an image.