Erik Remmelzwaal wrote:
The formula on the link was : {=MIN(IF((A1:A5>0)*(A1:A5),(A1:A5)))} (array
formular). However since calc uses ";" to separate arguments if you change
the formula to {=MIN(IF((A1:A5>0)*(A1:A5);(A1:A5)))} it works just fine.
I'm just wondering why one need as condition (A1:A5>0)*(A1:A5). I
think (A1:A5>0) is sufficient to get vector of true/false values.
Makes it more clear what is going on.
{=MIN( IF( A1:A5>0; A1:A5 ) ) } should do the job then.
Erik
Yes, definitely.
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.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
