Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

QUARTILE.INC Function in Excel

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

QUARTILE.INC Function in Excel

The QUARTILE.INC function, earlier as QUARTILE function in Excel is the replacement of 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.


= QUARTILE.INC (array, quart)


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

Usage Notes and Possible Error

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

How to use the QUARTILE.INC Function in Excel?

Using this function in a WS 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.INC Function in Excel?

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

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

You will get the result in the Result column.