Excel formula translator
Translator
Functions
Translation table
Error codes
Academy
🔍
Search functions
🌐 EN ▾
English
Deutsch
Français
Español
Português
☰
Home
›
Functions
›
Statistical
›
QUARTILE.INC
fx
QUARTILE.INC
Statistical
· Since: Excel 2003 · 9 languages
Returns the quartile of a data set, based on percentile values from 0..1, inclusive.
🌐
Translations
English
QUARTILE.INC
Deutsch
QUARTILE.INKL
Français
QUARTILE.INCLURE
Español
CUARTIL.INC
Italiano
INC.QUARTILE
Português
QUARTIL.INC
Nederlands
KWARTIEL.INC
Polski
KWARTYL.PRZEDZ.ZAMK
Русский
КВАРТИЛЬ.ВКЛ
📦
Availability
Excel version
Available
Excel 2007
✓
Excel 2013
✓
Excel 2019
✓
Excel 2021
✓
Microsoft 365
✓
Translate a formula with this function
fx
EN
=QUARTILE.INC(A2:A9,1)
fx
DE
⌨
Syntax
QUARTILE.INC(array,quart)
Arguments
array
(required)
— The array or cell range of numeric values for which you want the quartile value.
quart
(required)
— Indicates which value to return.
▶
Examples
=QUARTILE.INC(A2:A9,1)
Related functions
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BETA.DIST
BETA.INV
BINOM.DIST
Copied to clipboard
↑
↓
·
Enter
·
Esc
Excel functions ›