I think the array (3 values) returns the result of the first value eg
whatever is in the first cell, if you edit the array and select all of
it and press F9 you will see a combination of True and false for each
of the 3 conditions

=MAX((A1:A3<$B$1)*1) entered as an array will return a 1 if any of the
conditions is true, which is what u want, but I have not given any
thought as to how to turn this into a true.

Obviously 0 if none of the conditions is true


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=506716