To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101995 Issue #|101995 Summary|Array Formula; Max/Min Conditional Calculation Error Component|Spreadsheet Version|OOo 2.4.1 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|mikegsmith
------- Additional comments from [email protected] Sat May 16 20:57:41 +0000 2009 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
