using percentile in an array formula
 

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),Exi t_Date!$AF$184:$AF$228)

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

Bruce

using percentile in an array formula
 

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))
--
David Biddulph

"Bruce" wrote in message
...
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),Exi t_Date!$AF$184:$AF$228)

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

Bruce