QUARTILE
Returns the quartile of a data set. Replaced by QUARTILE.INC.
Syntax
QUARTILE(array, quart)
Parameters
- array: Required. The array or cell range of numeric values
- quart: Required. Indicates which value to return (0=min, 1=25th percentile, 2=median, 3=75th percentile, 4=max)
Example
=QUARTILE(A1:A10, 1)