using percentile in an array formula

[Bruce]

Hi,

I am trying to find the value of AF at the 25% percentile of AW in the
following array formula.

=IF(PERCENTILE(Exit_Date!$AW$184:$AW$228,0.25),Exit_Date!$AF$184:$AF$228)

I am getting a result but not the answer I am expecting.
Any ideas?

Bruce

 

[David Biddulph]

You might try
=INDEX(AF$184:$AF$228,MATCH(PERCENTILE($AW$184:$AW$228,0.25),AW$184:$AW$228))
if your data values in AW are in ascending order,
but in that situation you could also use
=INDEX(AF184:AF228,1+0.25*ROWS(AW184:AW228))