Quote:
Originally Posted by Colin Legg
Oh, but you can use formulas which return TRUE or FALSE as criteria too. For calculated criteria like this, you must leave the column header blank. For example, in the helpfile:
So with your formula:
=AND(E4>F9,D7<A5,M3>G1,B1=“FY 2010”)
It should return TRUE if all 3 criteria are met or FALSE if they aren't. When you use it in your criteria range, provided you have followed the rules in the helpfile, it should act as a filter accordingly. |
By the way...anyone reading this thread...if you read my original post, the problem and hence my conofusion, is that the third argument -> B1-"FY 2010", is not a third criteria, but the results displayed if the first two arguments, as criteria, is true.
My thought is that the entire example is incorrect, and that the third argument in the AND would be criteria, not results.