111StepsAhead, my example, which you quoted, was meant to correct the SYNTAX of a proper AND statement, wherein the logic test on each side of the AND must be a complete standalone test.
Now, an OR function operates exactly the same way.
The problem with using the OR function in this scenario is that this will ALWAYS be false, unless B = C. That's why I believe the AND function is appropriate for the OP's actual need.
The error Hello9000 was making was that his second logic test was only half stated:
...needed to be:
...but if he makes this correction, the result is most likely TRUE every time because nonDelete1 and nonDelete2 would most likely not be the same value.
EDIT: I also just noticed your negative rating to my post, makes no sense whatsoever. I not only understood what you were saying (Can you say, "Excel 101"?), I furthered your point by actually applying the idea you offered to an answer for the original poster, this forum isn't just about offering tidbits (which you did), but also offering a solution to the OPs question, which I did.
I thought your post plus mine gave the OP what he needed, but your negative use of the rating system clearly shows a lack of clarity on your part what this thread is actually about. Unfortunate.
Bookmarks