Thread: using percentile in an array formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruce Bruce is offline
external usenet poster
  
Posts: 138
Default 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
Reply With QuoteReply With Quote