Practice free

PERCENTILE.INC function

PERCENTILE.INC finds the value below which a chosen share of the data falls, such as the 90th percentile of response times. It interpolates between values when needed.

Example

Read it as a sentence: find the 25th percentile of A1:A8 using the inclusive method, which gives 4.

Practice this in the app

Syntax

PERCENTILE.INC(array, k)

array (required)
The data.
k (required)
Percentile as a fraction from 0 to 1.

Returns: The k-th percentile, with 0 giving the minimum and 1 the maximum.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=PERCENTILE.INC({10,20,30,40,50},0.9) 46 K 0.9 array
=PERCENTILE.INC(Data!A1:A8,0.25) 4 K 0.25
=PERCENTILE.INC(Data!A1:A8,0) 2 K 0
=PERCENTILE.INC(Data!A1:A8,1) 9 K 1
=PERCENTILE.INC(Data!A1:A8,0.05) 2.7 K very small (exc)
=PERCENTILE.INC(Data!A1:A8,{0.25,0.5,0.75}) 4 Array k (spills)
=PERCENTILE.INC(Data!A1:A8,-0.1) #NUM! K negative
=PERCENTILE.INC(Data!A1:A8,1.1) #NUM! K above 1

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • k is a fraction (0.9), not 90.
  • Same as the older PERCENTILE function.

Where it works

Excel
PERCENTILE.INC arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, but behaves differently. Sheets has PERCENTILE and PERCENTILE.INC; same method.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .