Excel QUARTILE.EXC function

Function              QUARTILE.EXC

Description        Excel QUARTILE.EXC function returns the most frequently occurring value of a number set. Here only First, Median and Third QUARTILE.EXC can be get.

Syntax  QUARTILE.EXC(array,quart)

Array     Required. The array or cell range of numeric values from which to get the quartile value.

Quart     Required. Indicates which value to return. Provides you with a drop down menu.

Example:

Usage Notes:

• If array is empty, it returns the #NUM! error value.
• If quart is not an integer, it is truncated to integer.
• If quart is other than 1,2,3 then it returns the #NUM! error value.