Compatibility - QUARTILE Function

The QUARTILE function replaces the QUARTILE.INC function in Excel 2010.

Description

The function returns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups.

QUARTILE (array,quart)

Argument	Description	Required/ Optional
Array	The array or cell range of numeric values for which you want the quartile value.	Required
Quart	Indicates which value to return. Look at the Quart Table below.	Required

Argument

Description

Required/ Optional

Array

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

Required

Quart

Indicates which value to return.

Look at the Quart Table below.

Required

Quart	QUARTILE returns
0	Minimum value
1	First quartile (25th percentile)
2	Median value (50th percentile)
3	Third quartile (75th percentile)
4	Maximum value

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

advanced_excel_compatibility_functions.htm