The OR function cannot be used in an array this way, since it only
returns a single result...

Cheers!

In article ,
ShaneDevenshire wrote:

Hi,

Second question:

=MEDIAN(IF(OR(EJ$2:EJ$5709="dulcer",EJ$2:EJ$5709=" decub"),IF(GJ$2:GJ$5709=0,IF
(GN$2:GN$5709="",GM$2:GM$5709))))

The OR can have up to 30 arguments.
--
Cheers,
Shane Devenshire