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

--
HTH

Kassie

Replace xxx with hotmail


"PAL" wrote:

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)