Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
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 version
Available
Excel 2007
✓
Excel 2013
✓
Excel 2019
✓
Excel 2021
✓
Microsoft 365
✓
Translate a formula with this function
fx
EN
=PERCENTILE.INC(A2:A5,0.3)
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
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BETA.DIST
BETA.INV
BINOM.DIST
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›