It returns the quartile of a data set. This function has been replaced by two new functions and you should avoid using it unless it is absolutely necessary. The new functions are QUARTILE.INC and QUARTILE.EXC.
QUARTILE(array,quart)
array: Required. The array or cell range of numeric values for which you want the quartile value.
quart: Required. Indicates which value to return
An empty array or a quart<0 or a quart>4 return the #NUM! error
MIN, MEDIAN, and MAX return the same value as QUARTILE when quart is equal to 0, 2, and 4, respectively
Here is an example of how to use the QUARTILE function:
In the cell B11 calculate the third quartile of the cell range B3:M6.