# PERCENTILE.EXC Function in Excel

In this article, you will learn about the PERCENTILE.EXC function, the formula syntax and usage of the function in Microsoft Excel.

## PERCENTILE.EXC Function in Excel

The PERCENTILE.EXC function in Excel calculates the “kth percentile” for a set of data where k is 0 to 1 exclusively.

Syntax

=PERCENTILE.EXC(array,k)

Arguments:

• array – The array or range of data defining relative standing.
• k – A value between 0 and 1 represents the Kth percentile.

#### Usage Notes and Possible Errors

• When the  array is empty, PERCENTILE.EXC function  returns the #NUM! error value
• In case of “k” being nonnumeric, PERCENTILE.EXC function returns the #VALUE! error value.
• If k is ≤ 0 or if k ≥ 1, the PERCENTILE.EXC function returns the #NUM! error value.
• When the argument k is not a multiple of 1/(n + 1), PERCENTILE.EXC interpolates to determine the value at the k-th percentile.
• The PERCENTILE.EXC function will interpolate when the value for the specified percentile lies between two values in the array. If it cannot interpolate for the percentile, k specified, Excel will return #NUM! error.

## How to use the PERCENTILE.EXC Function in Excel?

Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

Enter the data in the respective columns and enter the PERCENTILE.EXC formula.

Formula: =PERCENTILE.EXC(A2:A11,0.75)

Here, A2 refers to the cell name or the cell address that contains the array and the Kth value is determined as 0.75. You will get the result in the Result column.