How to Use Excel QUARTILE Function in Office 365? – [with Examples]
Tags: excelfunctions, excelquartilefunctio
Published: 2020-09-17 14:27:41

---
title: How to Use Excel QUARTILE Function in Office 365? – [with Examples]
published: true
date: 2020-09-17 09:19:38 UTC
tags: ExcelFunctions,ExcelQUARTILEFunctio
canonical_url: https://geekexcel.com/how-to-use-excel-quartile-function-in-office-365-with-examples/
---

## QUARTILE Function:

![QUARTILE Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/QUARTILE-Function.png)<figcaption id="caption-attachment-14090">QUARTILE Function</figcaption>

In this article, we are going to see the usage of **Excel QUARTILE Function in Office 365** with its syntax, explanation, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **QUARTILE Function – Explanation:**

- This function **returns the quartile of a given set of data**.
- QUARTILE function returns the **first**  **quartile** , **second**  **quartile** , **third**  **quartile** , **minimum** and **maximum** value.

## Syntax:

**=QUARTILE(array, quart)**

### Arguments Explanation:

**Array – ** It is the input array or cell range with numeric values for which you need to find the quartile value.

**Quart – ** This is the quartile value to return.

The quart argument determines which quartile value to return and it accepts only four values, they are given in the below table.

![QUARTILE Table](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/QUARTILE-Table.png)<figcaption id="caption-attachment-14088">QUARTILE Table</figcaption>

### Note:

- If the array is empty and then this function returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- If the quart argument is **less than 0 or greater than 4** , it will return [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- If the quart argument is non-numeric values such as letters and symbols and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

## Examples:

Let’s see some examples to clearly understand the **QUARTILE** function.

### Example 1:

- In the below image, you can be able to see the **input**  **range** in **Column B** , and its **quart** values are given in **Column D**.
- The **output** is listed in **Column E**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-61.png)<figcaption id="caption-attachment-14085">Example 1</figcaption>

### Example 2:

- If the quart argument is **less than 0 or greater than 4** , it will return [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-57.png)<figcaption id="caption-attachment-14086">Example 2</figcaption>

### Example 3:

- If the quart argument is non-numeric values such as letters and symbols and then this function returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-21.png)<figcaption id="caption-attachment-14087">Example 3</figcaption>

From the above examples, you can easily learn how to use the **QUARTILE** function.

## Closure:

In this article, you can understand the usage of **Excel QUARTILE Function in Office 365** with its syntax, explanation, and examples. Leave your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- **QUARTILE.EXC Function**
- **QUARTILE.INC Function**

### See Also:

- [How to Use Excel RANK.AVG Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-rank-avg-function-in-office-365-with-examples/)
- [How to Use Excel STDEV.S Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-stdev-s-function-in-office-365-with-examples/)