Article updated on March 09, 2018

The QUARTILE.INC function returns the quartile of a data set, based on percentile values from 0..1, inclusive.

Use the function to divide numerical values into groups.

Formula in cell E3:


Excel Function Syntax



array Required.The cell values for which you want to calculate the quartile value.
quart Required. Indicates which value to return.
Quart parameters
0 Minimum value.
1 First quartile (25th percentile).
2 Median quartile (50th percentile).
3 Third quartile (75th percentile).
4 Maximum value.