Compatibility - PERCENTILE Function

The PERCENTILE function replaces the PERCENTILE.INC function in Excel 2010.

Description

The function returns the k-th percentile of values in a range. You can use this function to establish a threshold of acceptance.

Syntax

PERCENTILE (array,k)

Arguments

Argument Description Required/ Optional
Array The array or range of data that defines relative standing. Required
K The percentile value in the range 0...1, inclusive. Required

Notes

  • If k is not a multiple of 1/(n - 1), PERCENTILE interpolates to determine the value at the k-th percentile.

  • If k is nonnumeric, PERCENTILE returns the #VALUE! error value.

  • If k is < 0 or if k > 1, PERCENTILE returns the #NUM! error value.

Example

PERCENTILE Function
advanced_excel_compatibility_functions.htm
Advertisements