Excel: Percentile Function

In Excel, the Percentile function returns the nth percentile from a set of values.

The syntax for the Percentile function is:

Percentile( array, nth_percentile )

array is a range or array from which you want to return the nth percentile.

nth_percentile is the percentile value. It can be a value between 0 and 1.

Note:

If nth_percentile is not a numeric value, the Percentile function will return the #VALUE! error.

If nth_percentile is a value greater than 1 or less than 0, the Percentile function will return the #NUM! error.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Percentile({1,2,3,4}, 0.8) would return 3.4

=Percentile(B3:B5, 0.75) would return 103.6

=Percentile({7,8,9,20}, 0.35) would return 8.05