How to use QUARTILE.EXC Function in Excel

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

Syntax:= QUARTILE.EXC (array, quart)

The QUARTILE.EXC function syntax has the following arguments:

• Array     Required. The array or cell range of numeric values for which you want the quartile value.

• Quart     Required. Indicates which value to return.

Example: Let’s look at some Excel QUARTILE.EXC function examples and explore how to use the QUARTILE.EXC function as a worksheet function in Microsoft Excel:

Example 1:

Suppose we are given the revenue figures below:

QUARTILE.EXC can return the first quartile, second quartile, and third quartile, as shown below:

Syntax:  =QUARTILE.EXC(A2:A9,B2)

Result: 23750000

Based on the Excel spreadsheet above, the following QUARTILE.EXC examples would return:

Note:

• If array is empty, QUARTILE.EXC returns the #NUM! error value.
• If quart is not an integer, it is truncated.
• If quart ≤ 0 or if quart ≥ 4, QUARTILE.EXC 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.