openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kadal Amutham <vka...@gmail.com>
Subject Re: Array formulas: maximum value – two conditions
Date Sat, 01 Jun 2013 02:48:56 GMT
The IF statement will expect a condition to test, not and another AND.

With Warm Regards

V.Kadal Amutham
919444360480
914422396480


On 1 June 2013 01:40, Johnny Rosenberg <gurus.knugum@gmail.com> wrote:

> Column C: Name
> Column D: Date
> Column H: Points
>
> I want to see the highest point for the name in P3 for dates in this
> year (2013).
>
> I can do highest score for the name that's stored in P3, regardless of the
> year:
> {=MAX(IF(C2:C10000=P3; H2:H10000; 0))}
> Result: 612.
> Expected result: 612.
>
> And the highest score for the this year, regardless of name:
> {=MAX(IF(YEAR(D2:D10000)=YEAR(TODAY()); H2:H10000; 0))}
> Result: 596.
> Expected result: 596.
>
> I tried the following:
> {=MAX(IF(AND(YEAR(D2:D10000)=YEAR(TODAY());C2:C10000=P3); H2:H10000; 0))}
> Result: 0.
> Expected result: 588.
>
> I obviously misunderstood the whole concept, so how is it supposed to be
> done?
>
>
> Johnny Rosenberg
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message