How to Use Excel QUARTILE.INC Function in Office 365?
Tags: excelfunctions, excelquartileincfunc
Published: 2020-09-17 14:27:52

---
title: How to Use Excel QUARTILE.INC Function in Office 365?
published: true
date: 2020-09-17 09:23:59 UTC
tags: ExcelFunctions,ExcelQUARTILEINCFunc
canonical_url: https://geekexcel.com/how-to-use-excel-quartile-inc-function-in-office-365/
---

## QUARTILE.INC Function:

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

In this post, we are going to explore how to use **Excel QUARTILE.INC Function in Office 365** with its syntax, explanation, and examples. Let’s get 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.INC Function – Explanation:**

- This function **returns the quartile of a given set of data**.
- **QUARTILE.INC** function returns the **first**  **quartile** , **second**  **quartile** , **third**  **quartile** , **minimum** and **maximum** value.
- This function is similar to the **QUARTILE**  **Function** in Excel.

## Syntax:

**=QUARTILE.INC(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.INC** function.

### Example 1:

- In this screenshot, you can be able to see the **input**  **values** 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-63.png)<figcaption id="caption-attachment-14116">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-58.png)<figcaption id="caption-attachment-14117">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-22.png)<figcaption id="caption-attachment-14118">Example 3</figcaption>

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

## Sum-Up:

This article helped you to understand the usage of **Excel QUARTILE.INC Function in Office 365** with its syntax, explanation, and examples. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

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

### Keep Reading:

- [How to Use Excel VARPA Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-varpa-function-in-office-365-with-examples/)
- [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/)