Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the quartile of the data set, based on percentile values from 0..1, exclusive.
Version Information
Version Added: Excel 2010
Syntax
expression .Quartile_Exc(Arg1, Arg2)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
Required |
Variant |
Array - The array or cell range of numeric values for which you want the quartile value. |
Arg2 |
Required |
Double |
Quart - The value to return. |
Return Value
Double
Remarks
If array is empty, QUARTILE_EXC returns the #NUM! error value.
If quart is not an integer, it is truncated.
If quart ≤ 0 or if quart ≥ 4, QUARTILE_EXC returns the #NUM! error value.
MIN, MEDIAN, and MAX return the same value as QUARTILE_EXC when quart is equal to 0 (zero), 2, and 4, respectively.