On Tue, 2011-12-06 at 10:57 +0100, [email protected] 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 <[email protected]> _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
