lundi 14 janvier 2019

Quartile function with multiple criteria

I am trying to find the 1st quartile from an array (Column AI) that is derived with a set criteria.

I Criteria = Only consider data with values between 5 and 10M in column L II Criteria = Only consider data with values between 50 and 100K in column R

I came up with the below but doesn't give me the correct value

=QUARTILE(IF((L:L>5000000)(L:L<10000000);IF((R:R>50000)(R:R<100000)))AI:AI;1)

Aucun commentaire:

Enregistrer un commentaire