The Excel QUARTILE function returns the quartile (each of four equal groups) for a given set of data. QUARTILE can return minimum value, first quartile, second quartile, third quartile, and max value.


Get the quartile in a data set

Return value 

Value for requested quartile


  • array - A reference containing data to analyze.
  • quart - The quartile value to return.


=QUARTILE(array, quart)

Usage notes 

Use the QUARTILE function to get the quartile for a given set of data. QUARTILE takes two arguments, the array containing numeric data to analyze, and quart, indicating which quartile value to return. The QUARTILE function accepts 5 values for the quart argument, as shown in the table below.

Quart Return value
0 Min value
1 First quartile – 25th percentile
2 Median value – 50th percentile
3 Third quartile – 75th percentile
4 Max value
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.