QUARTILE.INC function

Category: Statistical
Introduced: Excel 2010

Summary

Returns the quartile of a data set

Syntax

QUARTILE.INC(array,quart) The QUARTILE.INC function syntax has the following arguments:
• Array Required. The array or cell range of numeric values for which you want the quartile value.
• Quart Required. Indicates which value to return.

Example

=QUARTILE.INC(A2:A9,1)

Microsoft Support Page

https://support.microsoft.com/en-us/office/quartile-inc-function-1bbacc80-5075-42f1-aed6-47d735c4819d

Back to Functions