Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelQUARTILE Function in Excel

# 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

## 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

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.

### You May Also Like

#### SKEW.P Function in Excel

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

#### SKEW Function in Excel

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

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021