The PERCENTILE function syntax has the following arguments: array Required. The array or range of data that defines relative standing. k Required. The percentile value in the range 0..1, inclusive. Remarks. If k is non-numeric, PERCENTILE returns the #VALUE! error value. If k is 1, PERCENTILE returns the #NUM! error value. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.