Statistical

PERCENTILE.EXC Function in Excel

Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive.

Syntax

  • =PERCENTILE.EXC(array, k)

Arguments

  • array (required): Data array
  • k (required): Percentile value (0 to 1 exclusive)

Examples

  • =PERCENTILE.EXC(A1:A100, 0.25) - 25th percentile (exclusive) - Result: Percentile value

PERCENTILE.EXC for data analysis

  • Confirm whether you need entire columns, filtered subsets, or distinct values.
  • Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
  • Pivot tables complement single-cell statistical formulas for exploration.

Common errors

  • #NUM! if k <= 0 or k >= 1

Use cases

  • Statistical analysis
  • Data distribution
  • Outlier detection

Frequently asked questions

  • What is the PERCENTILE.EXC function in Excel? PERCENTILE.EXC returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive. The syntax is =PERCENTILE.EXC(array, k). Typical use cases include statistical analysis, data distribution, outlier detection.
  • How do I use the PERCENTILE.EXC function? To use PERCENTILE.EXC, type =PERCENTILE.EXC( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • What type of data does PERCENTILE.EXC work with? PERCENTILE.EXC works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
  • Why is PERCENTILE.EXC not working in my Excel? Common issues with PERCENTILE.EXC include #NUM! if k <= 0 or k >= 1. Start by checking the syntax =PERCENTILE.EXC(array, k), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.