View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PAL PAL is offline
external usenet poster
 
Posts: 200
Default Percentile Logic

I have two formulas, one to identify 75th percentile, the other 95th
percentile. They return the same value which makes no sense. They are both
arrays. Please advise.

=PERCENTILE(IF('1 Worksheet'!$H$2:$H$1309="",'1
Worksheet'!$I$2:$I$1309,""),0.75)


=PERCENTILE(IF('1 Worksheet'!$H$2:$H$1309="",'1
Worksheet'!$I$2:$I$1309,""),0.95)