Quote:
|
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.
|
Sorry, but that's incorrect.
In this formula:
=AND(E4>F9,D7<A5,M3>G1,B1="FY 2010")
All of the items inside the AND() are criteria.
E4>F9 is criteria1 - a comparison which returns True or False
D7<A5 is criteria2 - a comparison which returns True of False
M4>G1 is criteria3 - a comparison which returns True or False
B1="FY 2010" is criteria4 - a comparison which returns True or False
Then
=AND(criteria1 , criteria2, criteria3, criteria4)
returns True if all four criteria are True, otherwise it returns False.