Not so. Given no FALSE value is assigned to the IF a default Boolean False will be added to the Array of values.Originally Posted by Rydell
In this context given the Booleans are not constants they will not be coerced (ie they will not be treated as 0) - they will simply be ignored by MIN/MAX etc...
So to reiterate:
=MAX(IF(B1:B6>0,A1:A6))
=MIN(IF(B1:B6>0,A1:A6))
=MEDIAN(IF(B1:B6>0,A1:A6))
would all work as expected if correctly entered (& committed as Arrays via CTRL + SHIFT + ENTER)
Bookmarks