PERCENTILE Function Explained
The PERCENTILE function in Microsoft Excel returns the nth percentile from a set of values. It takes two arguments: an array of values and the percentile value (expressed as a decimal number between 0 and 1). The function returns the value at the given percentile in the array.
PERCENTILE Function Syntax
PERCENTILE(array, k)
array: The array of numbers for which you want to calculate the percentile.k: The percentile value you want to calculate. This number must be between 0 and 1.