View Single Post
 
Old 11-20-2012, 10:06 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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?
Reply With Quote