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

QUARTILE.EXC takes 2 required arguments and no optional arguments:

Syntax: QUARTILE.EXC(array, quart)

The arguments for the QUARTILE.EXC function are:
Argument Required? Description
array Required The array or cell range of numeric values for which you want the quartile value.
quart Required Indicates which value to return.
comments powered by Disqus