Excel QUARTILE function

Function              QUARTILE

Description        Excel QUARTILE function returns the most frequently occurring value of a number set.

Syntax  QUARTILE(array,quart)

Array     Required. The array or cell range of numeric values from which to get the quartile value.

Quart     Required. Indicates which value to return. Provides you with a drop down menu.

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

 Example:

Usage Notes:

  • If array is empty, it returns the #NUM! error value.
  • If quart is not an integer, it is truncated to integer.
  • If quart is other than 0,1,2,3,4 then it returns the #NUM! error value.