What is the syntax for QUARTILE.EXC in Excel?

The syntax for QUARTILE.EXC is: =QUARTILE.EXC(array, quart)

How do I use the QUARTILE.EXC function?

To use QUARTILE.EXC, type =QUARTILE.EXC( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What type of data does QUARTILE.EXC work with?

QUARTILE.EXC works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.

Why is QUARTILE.EXC not working in my Excel?

Common issues with QUARTILE.EXC include #NUM! if quart not 1, 2, or 3. Start by checking the syntax =QUARTILE.EXC(array, quart), then verify each referenced cell or range.

Statistical

QUARTILE.EXC Function in Excel

Returns the quartile of the data set, based on percentile values from 0..1, exclusive.

Syntax

=QUARTILE.EXC(array, quart)

Arguments

array (required): Data array
quart (required): Quartile (1, 2, or 3)

Examples

=QUARTILE.EXC(A1:A100, 1) - First quartile (exclusive) - Result: Q1 value

QUARTILE.EXC for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

#NUM! if quart not 1, 2, or 3

Use cases

Box plots
Data distribution
Statistical analysis

Frequently asked questions

What is the QUARTILE.EXC function in Excel? QUARTILE.EXC returns the quartile of the data set, based on percentile values from 0..1, exclusive. The syntax is =QUARTILE.EXC(array, quart). Typical use cases include box plots, data distribution, statistical analysis.
How do I use the QUARTILE.EXC function? To use QUARTILE.EXC, type =QUARTILE.EXC( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What type of data does QUARTILE.EXC work with? QUARTILE.EXC works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
Why is QUARTILE.EXC not working in my Excel? Common issues with QUARTILE.EXC include #NUM! if quart not 1, 2, or 3. Start by checking the syntax =QUARTILE.EXC(array, quart), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.