Home › Functions › Statistical › PERCENTILE.INC
fx
PERCENTILE.INC
Statistical  ·  Since: Excel 2003  ·  9 languages

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

🌐 Translations

English PERCENTILE.INC
Deutsch QUANTIL.INKL
Français CENTILE.INCLURE
Español PERCENTIL.INC
Italiano INC.PERCENTILE
Português PERCENTIL.INC
Nederlands PERCENTIEL.INC
Polski PERCENTYL.PRZEDZ.ZAMK
Русский ПРОЦЕНТИЛЬ.ВКЛ

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

PERCENTILE.INC(array,k)

Arguments

array (required) — The array or range of data that defines relative standing.
k (required) — The percentile value in the range 0 to 1, inclusive.

▶ Examples

=PERCENTILE.INC(A2:A5,0.3)

Related functions

Copied to clipboard