Statistical

PERCENTILE.INC Function in Excel

Returns the k-th percentile of values in a range (inclusive).

Syntax

  • =PERCENTILE.INC(array, k)

Arguments

  • array (required): Range of values
  • k (required): Percentile value between 0 and 1

Examples

  • =PERCENTILE.INC(A1:A100, 0.9) - 90th percentile - Result: Value at 90%
  • =PERCENTILE.INC(A1:A100, 0.5) - Median (50th percentile) - Result: Median value

PERCENTILE.INC 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

  • Performance thresholds
  • Distribution analysis
  • Outlier detection

Frequently asked questions

  • What's the difference between PERCENTILE.INC and PERCENTILE.EXC? PERCENTILE.INC includes 0 and 1 (0% and 100%), returning min/max values. PERCENTILE.EXC excludes them, requiring k between 1/(n+1) and n/(n+1). For most business uses, PERCENTILE.INC is preferred.
  • How do I find outliers using percentiles? Calculate IQR: Q1=PERCENTILE.INC(data, 0.25), Q3=PERCENTILE.INC(data, 0.75), IQR=Q3-Q1. Outliers are values < Q1-1.5*IQR or > Q3+1.5*IQR. Use conditional formatting to highlight them.

Editorial review

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