Excel QUARTILE Function
Summary
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.
Purpose
Get the quartile in a data set
Return value
Value for requested quartile
Syntax
=QUARTILE (array, quart)
Arguments
- array - A reference containing data to analyze.
- quart - The quartile value to return.
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 the 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 |
QUARTILE formula examples
To highlight cells by quartile, you can apply conditional formatting with a formula that uses the QUARTILE function.
In the example shown, we are using 4 different conditional formatting rules. Each rule highlights a...
Related functions
