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