Percentile Logic

  • Thread starter Thread starter PAL
  • Start date Start date
P

PAL

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)
 
I see my formula in response to your previous thread worked, you never
mentioned that!!

On what data do you get the same answer with these 2 formula?

Mike
 
You are not using PERCENTILE correctly. Loose the <=""> from the first range
and the <""> from the second range.

--
HTH

Kassie

Replace xxx with hotmail
 
Back
Top