Issue 101995 - Array Formula; Max/Min Conditional Calculation Error
Summary: Array Formula; Max/Min Conditional Calculation Error
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-05-16 21:57 UTC by mikegsmith
Modified: 2013-01-29 21:40 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Arrays - Max/Min Conditional Calculation Error (12.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-16 22:03 UTC, mikegsmith 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description mikegsmith 2009-05-16 21:57:41 UTC 
Documentation/How Tos/Using Arrays, p. 5 under Tips and Tricks ("Maximum in a
particular month")

Following described formula provides correct result:
 Max(If(Month(B1:B9)=5;C1:C9;0)).
Documentation says that the Min() function would provide the minimum value for
the month. However, following formula does not produce meaningful result:
 Min(If(Month(B1:B9)=5;C1:C9;0))

Small() and Large() functions will work in this instance.
Comment 1 mikegsmith 2009-05-16 22:03:27 UTC 
Created attachment 62316 [details]
Arrays - Max/Min Conditional Calculation Error
Comment 2 Regina Henschel 2009-05-17 22:02:21 UTC 
In MIN you use
    IF(MONTH(B$10:B$19)=5;C$10:C$19;0)
which sets the result to 0, if MONTH() unequal 5. Therefore the minimum is 0.

In SMALL you use
   IF(MONTH($B$10:$B$19)=5;C$10:C$19)
which is a form with only two parameters. It sets the result to the default
FALSE, if MONTH() unequal 5. Therefore the smallest is 28.

   =MIN(IF(MONTH($B$10:$B$19)=5;C$10:C$19))
will work as
   =SMALL(IF(MONTH($B$10:$B$19)=5;C$10:C$19);1)

But the question is, why FALSE is not evaluated as 0 in array context. I set
this issue to new, so that Eike can look, whether this is conform to ODF spec.