QUARTILE.EXC
Description
Returns the quartile of the specified list of values. Similar to QUARTILE() or
QUARTILE.INC() but QUARTILE.EXC() does not calculate the 0th or 4th quartile. The specified
values must be numeric; if a unit is included as part of a number, the function ignores
it.
Syntax
QUARTILE.EXC(
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.
Example
Formula | Result |
|---|---|
=QUARTILE.EXC({55,91,11},2) | 55 |