QUARTILE Function in Excel

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

QUARTILE Function in Excel

The QUARTILE function in Excel returns the quartile for a given set of data. Using the QUARTILE function, you can get the minimum value, first quartile, second quartile, third quartile, and max value.

Note: Excel has replaced this function with one or more new functions to improve accuracy along with the function names reflecting their usage. But still, the function is still available for backward compatibility, you should consider using the new functions like QUARTILE.EXC function and QUARTILE.INC function because this function may not be available in future versions of Excel.

Syntax

= QUARTILE(array, quart)

Arguments:

  • Array – The array or cell range of numeric values
  • Quart – Indicates which value to return
Quart ValueQUARTILE returns
0Minimum Value
1The first quartile (25th percentile)
2Median value (50th percentile)
3Third quartile (75th percentile)
4Maximum value

Usage Notes and Possible Errors

  • When an array is empty, the QUARTILE function returns the #NUM! Error value.
  • The quart value is truncated.
  • When the quart < 0 or if quart > 4, the QUARTILE function returns the #NUM! error value.
  • MIN, MEDIAN, and MAX return the same value as QUARTILE when quart is equal to 0 (zero), 2, and 4, respectively.

How to use the QUARTILE 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

How to use the QUARTILE function in Excel?

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

Formula: =QUARTILE(A2:A6, 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 0-4.

You will get the result in the Result column.