Re: DMEDIAN function / Re: [Bug 665308] DMEDIAN function

[Andreas Guelzow <aguelzow pyrshep ca>]

On Tue, 2011-12-06 at 10:57 +0100, so09 gmx de wrote:
> Dear Andreas, all,
>
> your solution (emails, 
> "http://projects.gnome.org/gnumeric/doc/sect-data-formulas.shtml#sect-data-formulas-database";) 
> does not generally work. It only works for special cases.
>
> "Multiple conditions can be combined using the AND or OR functions as in 
> median(if(OR(A1:A20="AA",A1:A20="BB"),B1:B20))." Yes and no. These 
> multiple conditions refer to one value only, namely the one in column A. 
> For multiple conditions regarding more than one value/column, this does 
> not work; see attached screenshot. (If I have it wrong, please correct 
> me. I did not find a solution in the documentation for Gnumeric or 
> LibreOffice.)
>
> Is there a solution using array funtions, or is this only possible with 
> database functions like daverage?
>
> Soeren

Thanks Soeren for pointing this out. In the context of array evaluation
OR (and AND) is applied to all 40 equality tests here. One would need to
use multiplication and addition for AND and OR respectively. I will fix
the documentation.

Andreas

-- 
Andreas Guelzow <aguelzow pyrshep ca>