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 versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
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

Copied to clipboard