Quote:
Originally Posted by Colin Legg
The helpfile that I have says that you can create AND and OR logic in your criteria by correctly laying out (horizontal and vertical) the criteria in a range.
For example, the helpfile says that to create this logic:
Boolean logic: (Salesperson = "Davolio" OR Salesperson = "Buchanan")
you have to lay out the Salespersons as a list in the same column (there's a picture demonstrating it).
If your source document is the helpfile then I think you've misunderstood "AND" and "OR" boolean logic to mean the AND() and OR() worksheet functions. If your document is something else then point us to it?
|
Thanks, yes, using it within a function as you describe would be able to be done, as you say.
I can't specifically point you to the document, as it is printed, and copyrighted. But I think that the document, on this particular topic, is written poorly. It lists it exactly as I wrote in the initial post. And it has the title on the page that it can be used that way in DB functions. Based on being written that way, and based on the fact that earlier in the document they discussed the AND and OR functions, also exampled the same way, I presumed that was what they meant.
I appreciate the feedback. I think the final thought is that they meant as you described, which then does make sense.