WorksheetFunction.Quartile_Exc Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns the quartile of the data set, based on percentile values from 0..1, exclusive.

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

  • 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.

Show: