QUARTILE.INC Function
Returns the chosen quartile (0=min to 4=max) using the inclusive method.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| array | The range or array of numeric values. | Required |
| quart | Quartile to return: 0, 1, 2, 3, or 4 (integer). | Required |
Basic Example
Median (second quartile) of eight values
=QUARTILE.INC({2,4,6,8,10,12,14,16}, 2)The median is the average of the 4th and 5th values: (8+10)/2 = 9.
Advanced Examples
Example 1: First quartile via inclusive interpolation
25th percentile of eight valuesEquivalent to PERCENTILE.INC with k = 0.25.
=QUARTILE.INC({2,4,6,8,10,12,14,16}, 1)Example 2: Third quartile
75th percentilequart = 3 corresponds to k = 0.75.
=QUARTILE.INC({2,4,6,8,10,12,14,16}, 3)How QUARTILE.INC Works
QUARTILE.INC uses the inclusive method, internally equivalent to PERCENTILE.INC(array, quart/4). It returns quart 0 (minimum), 1 (first quartile), 2 (median), 3 (third quartile), or 4 (maximum). The quartile position is interpolated linearly when fractional. quart must be an integer from 0 to 4, else #NUM!. It is functionally identical to the legacy QUARTILE. Text and logical values are ignored.
Important Notes & Limitations
quart must be an integer from 0 to 4; other values cause #NUM!.
Interpolates, so results may not equal actual data points.
Ignores text and logical values.
Common Errors & Fixes
#NUM! errorquart is outside 0..4 or non-integer, or the array is empty.Fix: Use an integer quart in 0..4 with a non-empty numeric range.
Result differs from QUARTILE.EXCThe two use different interpolation formulas.Fix: Use QUARTILE.EXC only when the exclusive method is required.
Download Practice File
QUARTILE.INC
quartile-incPractice QUARTILE.INC with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the QUARTILE.INC function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps