QUARTILE Function in Excel: Syntax and Examples

This article provides a clear overview of QUARTILE Function in Excel, with the main facts, useful context, and practical details organized for easy reading.

What This Feature Does

The function returns the quartile of a dataset. It is applied in survey and sales data.

Syntax

QUARTILE (array, quart) .

Arguments

- array: The dataset (by array or range of cells) needs to find the quartile value, is a required parameter.

- quart: Specifies the value to return, is a required parameter. Use one of these values:

+ quart = 0: Quartiles at minimum.

+ quart = 1: The first quartile (25th percentile).

+ quart = 2: Quartile at average value (50th percentile).

+ quart = 3: Quartile at the third value (75th percentile).

+ quart = 4: Quartile at maximum value.

Important Notes

- If array parameter is empty ? the function returns the value #NUM!

- If quart is decimal ? function takes integer value of quart.

- If quart is outside the value set {0, 1, 2, 3, 4} ? the function returns the #NUM! error value

- If quart = 0 ? has the same value as MIN function, quart = 2 ? has the same value for MEDIAN function, quart = 4 = same value for MAX function.

Example

- Calculate the percentile value of the following dataset:

1. Minimum Percentile

in the target cell enter the formula: = QUARTILE (B13: B17, C13) .

The minimum percentile has the same value as the MIN function:

2. 25th Percentile (Quarty = 1)

in the target cell enter the formula: = QUARTILE (B13: B17, C14) .

3. 50th Percentile

in the target cell enter the formula: = QUARTILE (B13: B17, C15) .

The 50th percentile has the same value as the MEDIAN function.

4. 75th Percentile

in the target cell enter the formula: = QUARTILE (B13: B17, C16) .

5. Percentage with Maximum Value

Enter the formula: = QUARTILE (B13: B17, C17) .

Maximum percentile value equal to the MAX function value: