Joe Smith wrote:
I thought I understood this at first, but now I surely don't.
Why does this work: =MIN( IF((A5:A9>0)*A5:A9; A5:A9))
While these do not: =MIN( IF((A5:A9>0)*A5:A9; A5:A9; 0))
=MIN( IF((A5:A9>0)*A5:A9; A5:A9; 0=1))
Actually, I understand why the last two _don't_ work, but it makes a
complete mystery of why the first one /does/.
I thought I was starting to get a handle on how array functions work,
but the more I see, the less I understand.
The first case (an empty "if" path) is recognized separately in the
intermediate result array. It's treated much like an empty value, turned
into FALSE (0 with boolean format) only when shown in a cell, converted
to text, etc.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
