# QUARTILE.EXC Function in Excel

In this article, you will learn about QUARTILE.EXC function, the formula syntax and usage of the function in Microsoft Excel.

## QUARTILE.EXC Function in Excel

The QUARTILE.EXC function in Excel returns the quartile for a given set of data. Unlike the quartile function, the QUARTILE.EXC function returns only the first quartile, second quartile, and third quartile.

#### Syntax

= QUARTILE.EXC(array, quart)

Arguments:

• Array     The array or cell range of numeric values.
• Quart     Indicates which value to return.

## Usage Notes and Possible Errors

• When the array is empty, the QUARTILE.EXC function returns the #NUM! error value.
• If quart is not an integer, it is truncated.
• When the quart is being “less than or equal to zero” or if quart is greater than or equal to four, the QUARTILE.EXC function returns the #NUM! error value.
• MIN, MEDIAN, and MAX return the same value as QUARTILE.EXC when quart is equal to 0 (zero), 2, and 4, respectively.

## How to use the QUARTILE.EXC function in Excel?

Using this function in a Worksheet is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

Enter the data in the respective columns and enter the QUARTILE.EXC function formula.

Formula: =QUARTILE.EXC(A2:A11, B2)

Here, A2 refers to the cell name or the cell address. Column A denotes the Array and Column B denotes the quart value. Here, we have shown all the quart values from 1-3.

You will get the result in the Result column.