How to Find the Minimum in Excel with the MIN Function

Formulas & functions · Updated November 20, 2026

To find the smallest number in Excel, use the MIN function. With the numbers you want to check in cells A2 through A20, enter =MIN(A2:A20) in an empty cell and press Enter. Excel returns the lowest numeric value in that range. You can also use the AutoSum menu to insert a minimum calculation without typing the function.

What You’ll Need

  • An Excel workbook containing the numbers you want to compare. These can be in one column, one row, or several ranges.
  • An empty cell for the result, preferably outside the range you are checking so the result does not become part of the calculation.
  • Microsoft Excel for Microsoft 365 on Windows for the steps below. MIN is also available in Excel for Mac and Excel for the web, although the ribbon layout can differ slightly.

No add-in or special setting is required. MIN works with ordinary numbers, dates, times, and cell references. If your worksheet contains numbers stored as text, check those cells before relying on the result, because MIN generally ignores text in referenced cells.

Step-by-Step

  1. Identify the values to compare. Find the cells that contain the numbers you want included. For example, if monthly quantities are in B2:B13, make a note of that range. Decide whether all the values should count, including zeros, negative numbers, and any results from formulas. MIN finds the lowest numeric value; it does not decide whether a value is an error or an outlier in your data.
  2. Choose a result cell. Click an empty cell where you want Excel to display the answer. Avoid putting the result inside the range being evaluated. If the result cell is part of the range, the formula may create a circular reference or include its own result in the calculation. A cell immediately below the data is often convenient, provided it is not itself included in the selected range.
  3. Type the MIN formula. With values in B2:B13, enter =MIN(B2:B13) in the result cell, then press Enter. The colon means “from the first cell through the last cell,” so Excel checks every cell from B2 to B13, including both endpoints. Replace the example references with the actual first and last cells in your data. In Excel for Windows, Enter confirms the formula; Excel for Mac also accepts the formula with Return or Enter, depending on the keyboard.
  4. Check the returned value against the data. Excel displays the smallest numeric value from the range. For example, if B2:B6 contains 12, 7, 3, 19, and 8, the answer is 3. If the answer is unexpected, scan the range for a zero, a negative number, or a value that is included accidentally. The displayed result may be rounded by cell formatting even when the underlying value has more decimal places.
  5. Use AutoSum if you prefer the ribbon. Click the empty result cell, then choose Home > Editing > AutoSum and select Min from its dropdown. Excel proposes a range, usually the adjacent block of numbers. Check the highlighted range before pressing Enter; adjust the references in the formula bar if Excel selected too many or too few cells. The AutoSum button may also appear on the Formulas tab, depending on the ribbon layout. On Mac and Excel for the web, look for AutoSum on the Home tab; labels and group placement can vary.
  6. Include more than one range when needed. MIN can compare separate ranges in one calculation. With values in A2:A6 and C2:C6, enter =MIN(A2:A6,C2:C6) in an empty result cell. Excel compares the numeric values in both ranges and returns the smallest one. For example, if the smallest number in A2:A6 is 3 and the smallest in C2:C6 is 2, the result is 2. Separate ranges with commas in a formula. Do not use a comma if you mean one continuous range; use a colon for that.
  7. Limit the minimum to values that meet a condition, if appropriate. For a conditional minimum, Microsoft 365 includes MINIFS. With regions in A2:A8 and corresponding amounts in B2:B8, enter =MINIFS(B2:B8,A2:A8,"North") to find the smallest amount for rows marked North. If the North amounts are 210, 125, 180, and 155, the result is 125. The minimum range and criteria range must line up row by row. MINIFS is available in Microsoft 365 and newer Excel versions, including Excel 2019; use MIN for an unrestricted minimum.
  8. Format the answer for readability. If the values represent money, dates, percentages, or measurements, format the result cell to match. Select the result cell and use the number-format controls on the Home tab. Formatting changes how the answer looks, not which value MIN selects. For example, a date is stored as a number in Excel, so MIN returns the earliest date when the range contains valid dates.

The basic MIN formula updates when values in its referenced cells change. If you add new rows below the range, however, Excel may not include them automatically when you typed a fixed range. Check the formula references after adding data, or place the data in an Excel table so expanding the table is easier to manage. Tables are useful for growing lists, but confirm that the formula refers to the intended table column rather than a separate, fixed range.

Common Mistakes

Using the wrong range: A formula can be syntactically correct and still give the wrong answer if it skips the first or last data row. Compare the formula references with the visible data and make sure headers and totals are not included by accident. If your values are in rows rather than columns, select the row range instead.

Assuming blanks and text count as zero: In a cell reference, blank cells and text entries are ignored by MIN; they are not treated as zero. A real numeric zero is included, though, and will be the minimum if the other numbers are positive. A number that looks like 0 but is stored as text may be ignored, which can make the answer seem too high.

Overlooking negative values or dates: A negative number is less than any positive number, so a single negative value can be the correct minimum. Dates are also numeric values under the hood, and an earlier date has a lower serial number. Check the meaning and formatting of the entries before assuming the lowest displayed number is a mistake.

Including a total or the result cell: A total, previous answer, or unrelated number within the selected range can change the result. Keep the range limited to the observations you intend to compare. Also avoid entering the formula in the range it references, which can cause a circular-reference warning.

Using MIN when you need a filtered minimum: Applying a worksheet filter does not make MIN automatically ignore rows hidden by that filter. MIN still considers values in the referenced range, including filtered-out records. Use MINIFS to apply a condition such as a category or region, or calculate the minimum from a deliberately selected range.

Tips

  • Use a direct cell range for a small, stable list; it makes the formula easy to inspect. Keep the range as narrow as practical instead of pointing at entire columns when the worksheet contains unrelated data.
  • For a list that will grow, consider converting the data to a table. Select a cell in the data and choose Insert > Table, making sure the header option matches your data. Table references can expand with added rows, but verify the formula after setting it up.
  • For a quick visual check, sort a copy of the data from smallest to largest or use Excel’s filter and sort controls. Sorting is not necessary for MIN, and it changes the order of the data, so avoid sorting if the original row order matters and the data is not safely selected as a complete table.
  • Keep units consistent. A list mixing dollars and cents, or minutes and seconds, can produce a mathematically correct but misleading minimum. Convert values to the same unit before comparing them.
  • When sharing the workbook, label the result cell, such as “Lowest reading,” and leave the formula visible in the formula bar. A clear label helps someone distinguish a calculated minimum from a manually entered value.

Troubleshooting

The answer is zero, but there are no visible zeros. Check for a zero hidden by formatting, a formula that returns zero, or an included cell outside the apparent data. Select cells in the range and inspect the formula bar. Also check for a zero in a filtered-out row, since a normal MIN calculation includes filtered-out values.

The answer is higher than the smallest number I can see. The apparent smallest entry may be stored as text rather than as a number. Select it and check whether Excel aligns it like text or shows a warning indicator; alignment alone is not conclusive because formatting can affect appearance. Convert the entry to a number using the warning menu when offered, or re-enter it as a numeric value. Then verify that the formula includes its cell.

Excel shows an error instead of a result. Check the referenced range for an error such as #VALUE! or #N/A. Errors in cells included in the calculation can cause the MIN formula to return an error. Correct the source error if possible, or revise the range to exclude cells that should not be part of the comparison. If the formula itself is rejected, check for a missing parenthesis or a misspelled function name.

The formula appears as text in the cell. The cell may be formatted as Text, or the formula may have been entered with an apostrophe before the equals sign. Change the cell format to General on the Home tab, then edit the cell and confirm the formula again. Changing the format alone may not recalculate an existing text entry; press F2 and then Enter on Windows, or edit and confirm the cell on Mac.

The displayed result does not change after editing a value. Confirm that the changed cell is within the formula’s range. Then check Formulas > Calculation Options and select Automatic if calculation is set to Manual. In Excel for Mac, the Calculation options are also on the Formulas tab, though the ribbon may be arranged differently. Press F9 on Windows to recalculate when needed; Mac keyboards may require Fn+F9 depending on system settings.

The result looks rounded. Select the result cell and increase the displayed decimal places from the Home tab. The formula may already be returning the precise minimum even if the cell displays fewer digits. Number formatting changes the display, not the underlying result.

Frequently Asked Questions

What is the Excel formula for finding the smallest number?
Use MIN with the cells or ranges to compare. For example, with values in D2:D50, enter =MIN(D2:D50) in an empty cell. Replace the range with the location of your own data.

Does MIN include blank cells?
No. Blank cells in a referenced range are ignored, as are text entries in cells. Numeric zero is included, so it can be returned as the minimum when it is the lowest number.

Can MIN find the smallest number across multiple columns?
Yes. Provide each range as a separate argument, or select one continuous range if all its cells should count. Make sure you do not include labels, totals, or unrelated values in those ranges.

How do I find the lowest value for one category?
Use MINIFS when available, giving it the values to compare and the matching category range and criterion. For example, it can find the minimum sales amount for one region without requiring you to remove other regions from the worksheet.

Does MIN ignore rows hidden by a filter?
No. MIN includes numeric cells in its referenced range even when their rows are filtered out. Use a conditional calculation such as MINIFS when the values you want are defined by a field, or work with a range containing only the records you intend to evaluate.

Can MIN find the earliest date?
Yes. Excel stores valid dates as serial numbers, so MIN returns the earliest date in the selected range. Format the result cell as a date if Excel displays a number instead of a calendar date.

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.