Excel - Microsoft Excel QUARTILE Function

Description

The Excel QUARTILE function returns a requested quartile of a supplied range of values. 

The format of the function is : 

QUARTILE( array, quart ) 

Where the function arguments are: 

Quartile Function Examples

The spreadsheets below show examples of the Excel Quartile function used to calculate the quartiles of the set of values 0 - 6 (stored in cells A1 - A7 of the sample spreadsheet). 

The formulas for the functions are shown in the spreadsheet on the left, and the results are shown in the spreadsheet on the right. 

Quartile Function Errors

If you get an error from the Excel Quartile function this is likely to be one of the following:

Common Errors