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