Statistical
Excel 2010
◉ 14 views
=QUARTILE.EXC()
QUARTILE.EXC returns the quartile of the data set, based on percentile values from 0..1, exclusive.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016Excel Web App
=QUARTILE.EXC(array, quart)
Hover argument names in the table for details.
Output typeNumber
Popularity12 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx — Coming soon
▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =QUARTILE.EXC() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
array |
Array | Required | The array or cell range of numeric values for which you want the quartile value. |
quart |
Number | Required | Indicates which value to return. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
6 |
A3 |
7 |
A4 |
15 |
A5 |
36 |
A6 |
39 |
A7 |
40 |
A8 |
41 |
A9 |
42 |
A10 |
43 |
A11 |
47 |
A12 |
49 |
A13 |
6 |
A14 |
7 |
A15 |
15 |
A16 |
36 |
A17 |
39 |
A18 |
40 |
A19 |
41 |
A20 |
42 |
A21 |
43 |
A22 |
47 |
A23 |
49 |
Locates the position of the first quartile (15).
=QUARTILE.EXC(A2:A12,1)
Result:
15
Locates the position of the third quartile (43).
=QUARTILE.EXC(A2:A12,3)
Result:
43
§ 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.
✦ Tips
- If quart is not an integer, it is truncated.
- MIN, MEDIAN, and MAX return the same value as QUARTILE.EXC when quart is equal to 0 (zero), 2, and 4, respectively.
⚠ Common Errors
#NUM!
If array is empty, QUARTILE.EXC returns the #NUM! error value. If quart ≤ 0 or if quart ≥ 4, QUARTILE.EXC returns the #NUM! error value.
Fix: Correct the input value
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!