Kornilios Ampatzis/ April 19, 2019/ Functions

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.

Share this Post