> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
