How to use the QUARTILE function
Author: Oscar Cronquist Article last updated on November 15, 2022
The QUARTILE function returns the quartile of a data set, use the QUARTILE function to divide data into groups.
This function is outdated and has been replaced with the newer QUARTILE.EXC and QUARTILE.INC function.
Formula in cell D3:
=QUARTILE(B3:B11,1)
Excel Function Syntax
QUARTILE(array, quart)
Arguments
| array | Required.The cell values for which you want to calculate the quartile value. |
| quart | Required. Indicates which value to return, see table below. |
| Quart parameters | |
|---|---|
| 0 | Minimum value. |
| 1 | First quartile (25th percentile). |
| 2 | Median quartile (50th percentile). |
| 3 | Third quartile (75th percentile). |
| 4 | Maximum value. |
Comments
The QUARTILE function returns #NUM! value if
- quart < 0 (zero)
- quart > 4
The QUARTILE function returns the same value as:
- MIN function if quart is 0 (zero)
- MEDIAN function if quart is 2.
- MAX function if quart is 4
Functions in 'Compatibility' category
The QUARTILE function function is one of many functions in the 'Compatibility' category.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form