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

It returns the quartile of a data set based on percentile values from 0..1, exclusive<\/strong>. <\/p>\n\n\n\n

QUARTILE.EXC<\/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.EXC when quart is equal to 0, 2, and 4, respectively<\/p>\n\n\n\n

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

Click on the button to practice using this function, with the help of our Online Assessment Tool<\/strong>:<\/p>\n\n\n

Practice<\/a><\/p>\n\n\n\n

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

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

In the cell B9 calculate the third quartile of the cell range B3:M6 inclusive.
In the cell B10 calculate the third quartile of the cell range B3:M6 exclusive.
In the cell B11 calculate the third quartile of the cell range B3:M6 using the simple QUARTILE function.<\/p>\n\n\n\n

\n