# Excel QUARTILE Function

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.

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

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 |

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.