PERCENTILE.EXC Function

Summary

PERCENTILE.EXC returns the value at a chosen percentile using the exclusive method. In practice, that means Excel treats the two outer edges differently from PERCENTILE.INC and focuses on percentiles inside the range rather than including the endpoints.

This function is useful when you want a cutoff such as the 75th or 90th percentile and you specifically want the exclusive version of the calculation. Microsoft notes that k must be greater than 0 and less than 1, and Excel interpolates when the requested percentile falls between two values.

PERCENTILE.EXC is useful when the workbook needs a threshold based on relative standing within the data. It helps answer questions like what value marks the top 10% or bottom quarter, while using the exclusive percentile convention.

Syntax

=PERCENTILE.EXC(array, k)

array is the numeric dataset, and k is the percentile written as a decimal. So 0.75 means the 75th percentile and 0.9 means the 90th percentile.

Arguments

• array - [required] The numeric range or array you want to evaluate.
• k - [required] The percentile as a decimal where 0 < k < 1.

PERCENTILE.EXC vs Other Functions

The key difference is the percentile rule. PERCENTILE.EXC does not allow k=0 or k=1, while PERCENTILE.INC does.

Using the PERCENTILE.EXC Function

This function is handy when you need a cutoff rather than a rank label. For example, if the 90th percentile score is 93, that tells you what score marks the top end of the group. That is often more useful than saying someone is ranked 4th, because the percentile gives you a threshold you can reuse.

Microsoft also notes two error rules worth remembering. If k is not numeric, Excel returns #VALUE!. If the array is empty, if k<=0, or if k>=1, Excel returns #NUM!. Even with a valid decimal, Excel can still return #NUM! if it cannot interpolate that percentile for the dataset size.

• Use it to set score cutoffs for top performers.
• Use it to split products into standard and premium groups.
• Use it when the exclusive method is specifically required.

Example 1 - Find the 90th percentile

This gives a high-end cutoff for the group.

=PERCENTILE.EXC(B1:B10,0.9) // Returns the 90th percentile of the list.

Example 2 - Mark the top quarter

The 75th percentile is a common way to separate the upper quarter from the rest.

=PERCENTILE.EXC(A1:A10,0.75) // Returns the 75th percentile.

Example 3 - Check the middle percentile

The 50th percentile is the midpoint under the exclusive method.

=PERCENTILE.EXC(B1:B10,0.5) // Returns the 50th percentile.

Example 4 - Set an 80th percentile target

This is useful when you want a target above the middle but below the very top.

=PERCENTILE.EXC(B1:B10,0.8) // Returns the 80th percentile.

Conclusion Recap

PERCENTILE.EXC is useful when you want a percentile cutoff but need the exclusive method instead of the inclusive one. This lesson showed that the function is really about finding a threshold, such as a top-tier score or a benchmark line, rather than finding one person’s rank.

The key thing to remember is the input rule for k. It has to stay strictly between 0 and 1, so this version does not include the outer endpoints. If you want a percentile method that can use 0 or 1, you would switch to PERCENTILE.INC instead.

• Main job: PERCENTILE.EXC returns a percentile cutoff using the exclusive method.
• k rule: Use a decimal strictly between 0 and 1.
• Interpolation: Excel calculates between values when the percentile falls between data points.
• Main contrast: Use PERCENTILE.INC if you need percentiles that include 0 or 1.
• Good use cases: Score cutoffs, pricing tiers, and benchmark targets.