How to Use Excel QUARTILE.EXC Function in Office 365?
Tags: excelfunctions, excelquartileexcfunc
Published: 2020-09-17 14:28:02

---
title: How to Use Excel QUARTILE.EXC Function in Office 365?
published: true
date: 2020-09-17 10:17:52 UTC
tags: ExcelFunctions,ExcelQUARTILEEXCFunc
canonical_url: https://geekexcel.com/how-to-use-excel-quartile-exc-function-in-office-365/
---

## QUARTILE.EXC Function:

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

In this tutorial, we will guide you to know how to use the **Excel QUARTILE.EXC**  **Function in Office 365** with its syntax, explanation, and examples. 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.EXC Function – Description:**

- This function **returns the quartile of a given set of data**.
- QUARTILE.EXC function can only return the **first** , **second** , and **third quartile**.

## Syntax:

**=QUARTILE.EXC(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 three values, they are listed in the below table.

![QUARTILE Table](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-62.png)<figcaption id="caption-attachment-14103">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 or equal to 0** or **greater than or equal to 4** , then it returns **[#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:

Here, we come up with some examples to make you understand how this function works.

### Example 1:

- In the below screenshot, 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/Example-1-1.png)](https://geekexcel.com/?attachment_id=14107#main)<figcaption id="caption-attachment-14107">Example 1</figcaption>

### Example 2:

- If the quart argument is **less than or equal to 0** or **greater than or equal to 4** , then it returns **[#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/Example-2-2.png)](https://geekexcel.com/?attachment_id=14108#main)<figcaption id="caption-attachment-14108">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/Example-3.png)](https://geekexcel.com/?attachment_id=14109#main)<figcaption id="caption-attachment-14109">Example 3</figcaption>

From the above examples, you can understand how to use **QUARTILE.EXC** Function in Excel.

## Verdict:

In this tutorial, we guided you to learn the usage of **Excel QUARTILE.EXC**  **Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Articles:

- [**QUARTILE Function**](https://geekexcel.com/how-to-use-excel-quartile-function-in-office-365-with-examples/)
- [**QUARTILE.INC Function**](https://geekexcel.com/how-to-use-excel-quartile-inc-function-in-office-365/)

### Read Ahead:

- [How to Use Excel MODE.MULT Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-mode-mult-function-in-office-365-with-examples/)
- [How to Use Excel ATAN Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-atan-function-in-office-365-with-examples/)