Joe Smith wrote:
So, in a normal expression, the result of IF( 0; 100 ) would be 0, but
here the result is nil (empty).
So if A5:A9 is {3,2,1,0,-1}, then
{=MIN( IF(A5:A9>0; A5:A9))} --> 1
{=COUNT( IF(A5:A9>0; A5:A9))} --> 3
{=SUM( IF(A5:A9>0; A5:A9))} --> 6
I never saw an IF with less than two arguments before, much less had any
idea that such a thing could produce an empty result in an array formula.
That's very handy! Is this behavior documented anywhere (I couldn't find
it in the online help for IF), or is it a wizard's secret?
It's a bit of a hack, to get the "FALSE" display while not counting it
as a value. The details may change one day, the existence of an "empty
path" result is an implementation detail that you shouldn't have to care
about.
Is there any way to make this explicit in the formula? E.g. to write IF(
0; 100; () ) to indicate that the empty result was intended.
It's not exactly the same, but for the formulas above, an empty string
behaves in a similar way. You can write {=MIN(IF(A5:A9>0;A5:A9;""))}.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
