Cellgrids Cellgrids
Home › Excel formulas › Statistical › QUARTILE.EXC

QUARTILE.EXC Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

QUARTILE.EXC is an Excel Statistical function. Returns the quartile of a data set, exclusive.

QUARTILE.EXC syntax

=QUARTILE.EXC(array, quart)

Arguments

When to use QUARTILE.EXC

QUARTILE.EXC is used in data analysis work to summarize or test patterns across a data set.

Practice QUARTILE.EXC online, free

Open the live Excel-style spreadsheet and try QUARTILE.EXC yourself. No Excel install or sign-up needed to start.

Practice QUARTILE.EXC now →

More Statistical functions

Frequently asked questions

What does the QUARTILE.EXC function do in Excel?

Returns the quartile of a data set, exclusive.

What is the syntax of QUARTILE.EXC in Excel?

The syntax is =QUARTILE.EXC(array, quart). array: The range or array to evaluate; quart: Which quartile to return.

Where can I practice QUARTILE.EXC online for free?

Open the free live spreadsheet on Cellgrids and try QUARTILE.EXC yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts