**QUARTILE.EXC Function:** Microsoft Excel is a powerful data visualization and analysis program used all around the world. It uses spreadsheets to **store**, **organize**, or **perform operations** with formulas and functions. If you want to get the quartile values for the given data set, you can use QUARTILE.EXC function.

In this tutorial, we will guide you to know how to use **Excel QUARTILE.EXC** **Function** 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

## Description of **QUARTILE.EXC Function**

- It is one of the built-in functions in Microsoft Excel.
- This function
**returns the quartile of a given set of data**. - QUARTILE.EXC function can only return the
**first**,**second**, and**third quartile**.

## Syntax

- Here, you will see the syntax of the QUARTILE.EXC function.
- To apply this function on your spreadsheet, you have to
**select a cell**and**enter the formula**in the following format. - Once you enter the formula, just
**click**on the**Enter**button to get the result.

**=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, which are listed in the below table.

**Note:**

1) If the array is empty and then this function returns **#NUM! Error**.

2) If the quart argument is **less than or equal to 0 or greater than or equal to 4**, then it returns **#NUM! Error**.

3) If the quart argument is non-numeric values such as letters and symbols and then this function returns **#VALUE! Error**.

## Examples

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

- Initially, you have to
**open**your**Excel workbook**on your PC and launch a worksheet that has data. - 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**. - We will get the quartile for a given set of data using the QUARTILE.EXC function.

- Then, we have to apply the above-mentioned formula in
**Cell F3**, as shown in the following screenshot.

- Finally, we need to
**click**on the**Enter**button to get the result. Then, you will need to drag down the first cell to fill the remaining range of cells.

- If the quart argument is
**less than or equal to 0**or**greater than or equal to 4**, it returns**#NUM Error**.

- If the quart argument is non-numeric values such as letters and symbols and then this function returns
**#VALUE! Error**.

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** with its syntax, explanation, and examples. Drop your **feedback** in the comment section. To learn more about Excel functions, then visit our webpage Aawexcel.com.

## Video Tutorial

The following video will show you how to apply Excel QUARTILE.EXC function in the worksheet.

**Read Ahead:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?

Hi there, I’m **Sridhar** – an Excel enthusiast with over **10 years** of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their **operations and save time and money**.

Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.