Quote:
Originally Posted by Pecoflyer
This statement is perfectly valid and will return FALSE or TRUE. What problem do you have?
|
Maybe my experimentation with it has been wrong.
The problem that I have is that the criteria in all the examples in the documentation (not using any AND statements in examples), expects a criteria statement, such as B1=FY 2010, not a True or a False value. It is referring to DB functions.
Below is the definition of what Criteria is from the Excel Help:
Quote:
|
Criteria is the range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column
|
That is not a True or False value. I've tried entering the AND in the criteria similar to the example and it always returns an error. Again, the document says that the AND and OR functions can be used as Criteria in DB function. It appears to me the document I am reading is wrong.