QUARTILE.EXC function
Summary
Returns the quartile of the data set, based on percentile values from 0..1, exclusive
Syntax
QUARTILE.EXC(array, quart)
The QUARTILE.EXC function syntax has the following arguments:
• Array Required. The array or cell range of numeric values for which you want the quartile value.
• Quart Required. Indicates which value to return.
• Array Required. The array or cell range of numeric values for which you want the quartile value.
• Quart Required. Indicates which value to return.
Example
=QUARTILE.EXC(A2:A12,1)
=QUARTILE.EXC(A2:A12,3)
=QUARTILE.EXC(A2:A12,3)