{"id":742,"date":"2019-04-19T11:13:03","date_gmt":"2019-04-19T08:13:03","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=742"},"modified":"2019-04-19T11:27:38","modified_gmt":"2019-04-19T08:27:38","slug":"the-quartile-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-quartile-function\/","title":{"rendered":"The QUARTILE function"},"content":{"rendered":"\n

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<\/a><\/strong> and QUARTILE.EXC<\/a><\/strong>.<\/p>\n\n\n\n

QUARTILE<\/strong>(array<\/strong>,quart<\/strong>)<\/p>array<\/strong>: Required. The array or cell range of numeric values for which you want the quartile value.
quart<\/strong>: Required. Indicates which value to return<\/cite><\/blockquote>\n\n\n\n

<\/div>\n\n\n\n

An empty array or a quart<0 or a quart>4 return the #NUM! error<\/p>\n\n\n\n

MIN<\/a><\/strong>, MEDIAN<\/a><\/strong>, and MAX <\/a><\/strong>return the same value as QUARTILE when quart is equal to 0, 2, and 4, respectively<\/p>\n\n\n\n

<\/div>\n\n\n\n

Here is an example of how to use the QUARTILE function:<\/strong><\/p>\n\n\n\n

In the cell B11 calculate the third quartile of the cell range B3:M6.<\/p>\n\n\n\n

\n