English Español Deutsch 日本語 Français Português Русский Italiano Nederlands Polski

Quick Navigation

QUARTILE Function

Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365

Summary

The QUARTILE function calculates quartile values from a dataset, dividing data into four equal parts for statistical analysis. This legacy function identifies minimum, first quartile (25th percentile), median, third quartile (75th percentile), or maximum values.

Syntax

QUARTILE(array, quart)

Parameters

Parameter Type Required Description
array Range/Array Yes The dataset of numeric values to analyze
quart Number Yes Specifies which quartile to return (0-4)

Using the QUARTILE Function

QUARTILE helps segment datasets into quartiles, essential for understanding data distribution in business analytics, market research, and statistical reporting. Use it to identify performance thresholds, income brackets, or sales percentiles.

Common QUARTILE Examples

Find First Quartile (25th Percentile)

=QUARTILE(A1:A10,1)

Returns the value below which 25% of data falls (e.g., 3.5 for sample data)

Calculate Median Value

=QUARTILE(A1:A10,2)

Identifies the middle value (50th percentile) of the dataset

Get Third Quartile

=QUARTILE(A1:A10,3)

Returns value below which 75% of data falls

Frequently Asked Questions

0 (minimum), 1 (first quartile), 2 (median), 3 (third quartile), 4 (maximum)

Microsoft recommends QUARTILE.INC or QUARTILE.EXC for new workbooks due to improved accuracy

Returns #NUM! error

Common Errors and Solutions

#NUM! error

Cause: quart < 0 or quart > 4, or non-integer quart value

Solution: Use integer values 0-4 for quart parameter

#NUM! error

Cause: Empty array or range

Solution: Ensure array contains numeric data

#VALUE! error

Cause: Non-numeric values in array

Solution: Clean data or use appropriate range

Notes

  • Legacy function - consider QUARTILE.INC/EXC for new spreadsheets
  • Truncates non-integer quart values
  • MIN, MEDIAN, MAX match QUARTILE(array,0), QUARTILE(array,2), QUARTILE(array,4)
  • Available in Excel 2007 through Excel 365

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 365