QUARTILE.INC Function
Returns a quartile of a data set (0 = minimum, 4 = maximum).
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
Quartiles split sorted data into four equal parts. QUARTILE.INC returns quartile 0 (minimum), 1 (25th percentile), 2 (median), 3 (75th percentile) or 4 (maximum).
The .INC version includes the end points (0 and 1, the smallest and largest values); the .EXC version excludes them and needs k strictly between them, so it can't reach the minimum or maximum. Both interpolate between values when k falls between two data points.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| array | Yes | The range of numbers. |
| quart | Yes | 0, 1, 2, 3 or 4. |
Examples
Example 1 — Five-number summary
The five quartiles describe the spread of the sales.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Quartile | Value |
| 2 | Ana | North | 62000 | 0 | 39800 |
| 3 | Ben | South | 48500 | 1 | 48500 |
| 4 | Cy | North | 50000 | 2 | 50000 |
| 5 | Di | East | 71250 | 3 | 58700 |
| 6 | Ed | South | 39800 | 4 | 71250 |
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
Example 2 — Interquartile range (IQR)
The middle 50% of results spans Q3 − Q1.
Returns 10,200. Values more than 1.5 × IQR beyond Q1 or Q3 are often treated as outliers.
Common mistakes
- #NUM! quart is below 0 or above 4.
Notes
- QUARTILE.INC(…,1) is the same as PERCENTILE.INC(…,0.25).
- Related functions: QUARTILE.EXC, PERCENTILE.INC, MEDIAN, MIN, MAX.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.