Excel Functions

Excel QUARTILE Function

Pinterest LinkedIn Tumblr

QUARTILE functions are used to find the various quartiles of a data set. A quartile is just a quantile.

Purpose of Excel QUARTILE Function

Get quartile of a set

Return value

Returns the quartile of a data set.




arrayThe range for which you need quartile value.Mandatory
quartIndicates which value to get.Mandatory

Usage notes

  • It can be used as a worksheet function.
  • It returns a numeric value.
  • It was first introduced in Excel 2000, and is now available in all subsequent versions of excel.
  • If the value of Quartile parameter is greater than 4 or less than 0 the function returns a #NUM! Error.
  • QUARTILE function #VALUE! Error if the given value of quart is non-numeric.


Since 2000 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment