QUARTILE.EXC Function
Returns quartile 1, 2 or 3 using the exclusive method.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
QUARTILE.EXC returns the 1st, 2nd or 3rd quartile using the (n + 1) method, matching many statistics packages. Quartiles 0 and 4 aren't available.
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 | 1, 2 or 3. |
Examples
Example 1 — Quartiles (exclusive)
Compare with QUARTILE.INC: Q3 is 62,000 here, against 58,700.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Quartile | Value |
| 2 | Ana | North | 62000 | 1 | 48500 |
| 3 | Ben | South | 48500 | 2 | 50000 |
| 4 | Cy | North | 50000 | 3 | 62000 |
| 5 | Di | East | 71250 | ||
| 6 | Ed | South | 39800 | ||
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
Common mistakes
- #NUM! quart is 0 or 4 (or anything other than 1–3), or there are too few values.
Notes
- Related functions: QUARTILE.INC, PERCENTILE.EXC, MEDIAN.

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.