Statistical
QUARTILE.INC Function in Excel
Returns the quartile of a data set (inclusive).
Syntax
- =QUARTILE.INC(array, quart)
Arguments
- array (required): Range of values
- quart (required): Quartile: 0=min, 1=25%, 2=50%, 3=75%, 4=max
Examples
- =QUARTILE.INC(A1:A100, 1) - First quartile (25%) - Result: Q1 value
- =QUARTILE.INC(A1:A100, 3) - Third quartile (75%) - Result: Q3 value
QUARTILE.INC for data analysis
- Confirm whether you need entire columns, filtered subsets, or distinct values.
- Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
- Pivot tables complement single-cell statistical formulas for exploration.
Common errors
- #NUM! if quart < 0 or quart > 4
Use cases
- Box plots
- Distribution analysis
- IQR calculations
Frequently asked questions
- How do I calculate IQR (Interquartile Range)? IQR = Q3 - Q1 = QUARTILE.INC(data, 3) - QUARTILE.INC(data, 1). IQR measures the spread of the middle 50% of data and is used for outlier detection and box plots.
- Is QUARTILE.INC(data, 2) the same as MEDIAN? Yes! QUARTILE.INC(data, 2) returns the same value as MEDIAN(data). Both calculate the 50th percentile (middle value) of the dataset.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.
When to use QUARTILE.INC
- Box plots — common Statistical scenario for QUARTILE.INC.
- Distribution analysis — common Statistical scenario for QUARTILE.INC.
- IQR calculations — common Statistical scenario for QUARTILE.INC.
QUARTILE.INC in the Statistical category
- Browse all Statistical functions at /categories/statistical/ for related formulas.
- QUARTILE.INC syntax: =QUARTILE.INC(array, quart)
- array (required): Range of values
- quart (required): Quartile: 0=min, 1=25%, 2=50%, 3=75%, 4=max
- Confirm QUARTILE.INC arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
Formula checklist before you copy down
- Confirm QUARTILE.INC arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
- If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
- Spot-check three known input rows manually against expected output.
Related Excel functions
- QUARTILE.EXC (/functions/quartile-exc/): Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
- PERCENTILE.INC (/functions/percentile-inc/): Returns the k-th percentile of values in a range (inclusive).
- MEDIAN (/functions/median/): Returns the median (middle value) of the given numbers. The median is the number in the middle of a set of numbers.
Errors to watch for
- #NUM! if quart < 0 or quart > 4 — review causes on linked error pages in the directory.
Copy-paste audit workflow
- Enter QUARTILE.INC on three test rows with known expected output documented on a QA tab.
- Fill down only after absolute references are locked on lookup tables and rate tables.
- Compare against manual calculation or a calculator for financial and statistical functions.
- Search this directory for comparison guides when choosing between similar functions in the same category.
QUARTILE.INC worked examples to copy
- =QUARTILE.INC(A1:A100, 1) — First quartile (25%). Expected result: Q1 value.
- =QUARTILE.INC(A1:A100, 3) — Third quartile (75%). Expected result: Q3 value.
QUARTILE.INC reference summary for crawlers and offline review
- QUARTILE.INC belongs to the Statistical category in Excel. Returns the quartile of a data set (inclusive).
- Full syntax: =QUARTILE.INC(array, quart). Open /functions/quartile-inc/ for parameters, FAQs, and related pages.
- Common mistakes: #NUM! if quart < 0 or quart > 4
- Pair this function with comparison guides when another Excel formula might fit the same task better.
- Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.