QUARTILE.INC
Description
Returns the quartile of the specified list of values. The specified values must be numeric;
if a unit is included as part of a number, the function ignores it.
Syntax
QUARTILE.INC(
array
,
quart
)
- array: The list of values to calculate the quartile for.
- quart: The quartile to calculate. 1 = 25th percentile; 2 = 50th percentile; 3 = 75th percentile; 4 = 100th percentile. Specifying 0 returns 0 as the result.
Example
Formula | Result |
|---|---|
=QUARTILE.INC({55,91,11},2) | 55 |