Google Sheets Function

QUARTILE.INC

Return the minimum, quartiles, or maximum of a dataset.

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

QUARTILE.INC(array, quart)

QUARTILE.INC returns one of five cut points from a dataset: minimum, first quartile, median, third quartile, or maximum. It is a convenient wrapper around percentile-style distribution analysis.

Arguments

arrayrequiredThe range of numeric values.
quartrequired0 for min, 1 for Q1, 2 for median, 3 for Q3, 4 for max.

Examples

=QUARTILE.INC(A2:A100, 3)

Result: 88

Returns the third quartile.

FAQ

Is quartile 2 the median?

Yes. QUARTILE.INC(array, 2) returns the median of the dataset.

Related functions

MIN MAX