First Quartile in Excel: Find It With a Simple Formula

Formulas & functions · Updated November 20, 2026

To find the first quartile (Q1) in Excel, use =QUARTILE.INC(A2:A9,1) when your numeric data is in A2:A9. The formula returns the value at the 25th percentile using Excel’s inclusive quartile method. Before entering it, check that the range contains the data you want to analyze and does not include a heading or unrelated values.

Q1 marks the point at or below which roughly 25% of the observations fall. It is useful for summarizing a data set, comparing groups, and understanding a box-and-whisker plot. Excel also offers an exclusive method, so if a report, class, or workplace specifies a particular quartile convention, use that convention consistently.

What You’ll Need

  • A Microsoft Excel workbook. The steps below are for Excel for Microsoft 365 on Windows; the same formulas work in current Excel for Mac and Excel for the web.
  • A column or row of numeric observations, such as measurements, test scores, or sales amounts. The data can be unsorted.
  • A blank cell for the result. If you want to compare methods or keep a record of the calculation, use a separate result cell and label it Q1.

Step-by-Step

  1. Enter or locate the numbers. Put one observation in each cell in a single row or column. For the worked example, enter 10, 12, 14, 16, 18, 20, 22, and 24 in cells A2 through A9, in that order. A1 can contain a heading such as Score, but keep it out of the calculation range. Your own values do not need to be sorted before you use the formula.

  2. Choose a result cell. Click an empty cell away from the data, such as C2. Keeping the result outside the data range makes it easier to see what Excel calculated and helps prevent the result from being included accidentally if you later expand or reuse the range.

  3. Enter the inclusive Q1 formula. With the eight example numbers in A2:A9 and the result cell C2 selected, type =QUARTILE.INC(A2:A9,1) and press Enter. The arguments mean: use the values in A2:A9, and return quartile 1. Excel displays 13.5. The function is available in Microsoft 365 and current desktop Excel versions.

  4. Check how the result is calculated. For these eight values, the inclusive method locates Q1 at position 1 + (8 − 1) × 0.25, or position 2.75 in the sorted data. The second value is 12 and the third is 14; 75% of the way from 12 to 14 is 13.5. This interpolation explains why the result does not have to be one of the original observations.

  5. Use the percentile version if that is clearer. With the example values in A2:A9, the equivalent inclusive calculation is =PERCENTILE.INC(A2:A9,0.25). It asks Excel for the 25th percentile rather than naming the quartile directly. For a clean numeric range, it returns the same 13.5 as QUARTILE.INC with quart set to 1.

  6. Use the exclusive method only when it is required. With the same eight values in A2:A9, enter =QUARTILE.EXC(A2:A9,1) in a blank result cell to calculate Q1 using the exclusive convention. It returns 12.5 for this example. The answer differs because the method positions quartiles differently; neither result is automatically an error. Follow the definition required by your assignment or analysis.

  7. Label and preserve the result. Add a nearby label such as Q1 (inclusive) so you and other workbook readers know which convention you used. If you share the sheet, state the source range and method in a note or a neighboring cell. This is especially helpful when the exclusive method is also reported or when the range may change later.

Common Mistakes

Choosing the wrong convention: QUARTILE.INC and QUARTILE.EXC can return different answers, particularly in small data sets. Many general Excel instructions use the inclusive function, but an assignment, standard, or organization may specify exclusive quartiles. Check the requested method before comparing your answer with someone else’s.

Using the wrong quartile number: The second argument is a number from 0 to 4. Use 1 for Q1, 2 for the median, and 3 for Q3. Entering 25 as the quartile argument because Q1 represents 25% is a common misunderstanding; for QUARTILE.INC, the argument is 1, not 25.

Including the heading or the wrong cells: Select only the observations. A text heading is generally ignored in a cell reference, but including unrelated numbers, totals, or another group will change the answer. Check the range shown in the formula bar or select the intended cells carefully.

Assuming the data must be sorted: Sorting is not required. Excel calculates the quartile from the values in the selected range. Sorting may help you inspect the data, but it will not fix an incorrect range or a mistaken quartile convention.

Expecting Q1 to be an observed value: Excel can interpolate between two values, as it does in the example. A decimal result is normal even if every input is a whole number. Do not round the answer unless your reporting instructions require it.

Tips

Use a clear, consistent data layout: one observation per cell, with a single heading above the list if needed. Avoid adding subtotals or explanatory text inside the observations. This makes it easier to select a reliable range and to spot missing or extra entries.

If you have a table that may grow, consider converting the data range to an Excel table with Insert > Table. A structured reference can make formulas easier to read and may expand as rows are added, but check the reference Excel creates so the calculation includes only the intended numeric column. If you are unfamiliar with structured references, a direct cell range is perfectly suitable.

Keep the function name explicit. QUARTILE.INC makes the chosen method visible to someone reviewing the workbook. The older QUARTILE function is retained for compatibility and corresponds to the inclusive method, but the .INC name makes your choice less ambiguous.

For a recurring report, place the quartile label and result beside the source data, and format the result to a sensible number of decimal places. Number formatting changes how a value looks, not the underlying calculated value. For example, displaying 13.5 with zero decimal places may make it appear as 14, even though the stored result remains 13.5.

Excel formulas normally use commas between arguments in the examples here. Some regional settings use semicolons as separators. If Excel rejects a formula with commas, use the separator expected by your installation; do not change the function name or the numeric meaning of the arguments. Function names and separators can also depend on Excel’s language and regional configuration.

When comparing results across software or textbooks, write down the convention as well as the value. Different tools can use different quartile definitions by default. Reporting Q1 = 13.5 using the inclusive method is more informative than reporting only Q1 = 13.5, particularly when another person needs to reproduce your calculation.

Troubleshooting

The formula appears as text instead of returning a number: The cell may be formatted as Text, or the entry may have a leading apostrophe. Change the cell format to General or Number, then re-enter the formula. Simply changing the format after typing may not convert an existing text entry, so edit and confirm the formula again.

You see a formula error: Check that the range contains at least one usable numeric value and that the quartile argument is within the supported range. For Q1, the argument should be 1. Also confirm that every parenthesis is closed and that your Excel installation accepts the comma separator used in the examples. A #NUM! error can result from an empty array or an invalid quartile argument.

The answer is different from a reference answer: First compare the exact input values and range, then check whether the reference uses inclusive or exclusive quartiles. For the example values 10 through 24 in steps of 2, the inclusive result is 13.5 and the exclusive result is 12.5. If the data sets and methods match but the answers do not, look for a missing value, a duplicate, a total included in the range, or a number stored as text.

New data is not reflected: Inspect the formula’s range. A formula referring to A2:A9 will not include a value subsequently typed in A10. Expand the range, or use a table-based reference if you expect the list to grow. Also check that calculation is set to Automatic under Formulas > Calculation Options if the workbook appears not to recalculate after an edit.

The result is unexpectedly rounded: Select the result cell and inspect the formula bar or increase the displayed decimal places from the Home tab’s Number group. The cell may be formatted to show fewer decimals than the calculated result. Avoid changing the underlying value with rounding unless that is part of your analysis.

Frequently Asked Questions

What is the Excel formula for the first quartile?
Use QUARTILE.INC with the data range and 1 as the quartile argument. For example, when the data is in A2:A9, the formula is =QUARTILE.INC(A2:A9,1). The result is the inclusive first quartile.

Is Q1 the same as the 25th percentile?
In the inclusive method, yes: Q1 is the 25th percentile. PERCENTILE.INC with 0.25 returns the same result as QUARTILE.INC with 1 for the same numeric range. Other conventions can define positions differently, so identify the method when exact comparison matters.

Should I use QUARTILE.INC or QUARTILE.EXC?
Use the method specified by your teacher, report, or analysis standard. If none is specified, QUARTILE.INC is a common choice for a general Excel calculation. The two methods can differ, so do not switch between them when comparing groups or reporting results.

Do I need to sort the data first?
No. Excel evaluates the values in the selected range and determines their order as part of the calculation. Sorting is optional and can make the values easier to inspect, but it is not a requirement for either quartile function.

Why is my first quartile a decimal?
Excel may interpolate between two observations to calculate Q1. In the example, 13.5 lies between 12 and 14 because the inclusive method places the first quartile between those sorted values. A decimal result is expected and does not mean the formula is wrong.

Can I use the same steps in Excel for Mac or the web?
Yes. QUARTILE.INC and PERCENTILE.INC work in current Excel for Mac and Excel for the web, and the basic formula entry is the same. If your regional settings use semicolons between function arguments, use the separator your version of Excel expects.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.