QUARTILE.EXC function

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

Syntax

QUARTILE.EXC(array,quart)

Argument	Description	Remarks
array	The array or cell range of numeric values for which you want the quartile value.	If this argument is empty, this function returns the #NUM! error value.
quart	Indicates which value to return.	If this argument is equal to or less than zero, this function returns the #NUM! error value. If this argument is equal to or greater than 4, this function returns the #NUM! error value. If this argument contains a decimal value, this function ignores the numbers to the right side of the decimal point.

MIN, MEDIAN, and MAX return the same value as QUARTILE.EXC when quart is equal to 0 (zero), 2, and 4, respectively.

Share your feedback about this topic

Rate this content: