It looks to me like the MAX and MIN functions are working just as they
are designed to. Let me see if I can explain.

As noted: the array formula (A1:A6)0,A1:16) returns the arrays
{TRUE;FALSE;TRUE;FALSE;FALSE;TRUE}{6;0;8;0;0;3}. The MIN function
looks at each element of each input array and returns the smallest
value, ignoring boolean and text values. So, to the MIN function, the
array looks like {TRUE;FALSE;TRUE;FALSE;FALSE;TRUE;6;0;8;0;0;3}. With
this array as input, and ignoring Boolean values, the smallest
numerical value in the array is 0. The largest numerical value is 8.
(Aside: If you really think the MAX function is working correctly, see
what happens if you switch to negative numbers and try to return the
largest value that is less than 0. In this scenario, the MIN function
will appear to work correctly, but the MAX function won't).

You noted that the function MIN(IF(A1:A60,A1:A6)) works. If we look
at this carefully, we see that the array returned by the inner IF
function would be {6;FALSE;8;FALSE;FALSE;3}. With this array as input,
and ignoring boolean values, the smallest value is indeed 3.

Does that make sense?

I'm not an expert on array formulas, but I'm reasonably confident that
that's why it isn't working for you.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=375644