How to Find the Lowest Number in Excel with MIN Formula

Formulas & functions · Updated November 20, 2026

To find the lowest number in a range, enter =MIN(A2:A20) in an empty cell, replacing A2:A20 with the cells you want to check, then press Enter. Excel returns the smallest numeric value in that range. The steps below explain how to choose the right cells and what to check if the result is not what you expect.

What You’ll Need

  • An Excel workbook containing the numbers you want to compare. The instructions are for Excel for Microsoft 365 on Windows; the MIN formula works in current desktop, Mac, and web versions too.
  • A blank cell for the result. It can be on the same worksheet or another worksheet in the workbook.
  • A clear idea of which values should count. For example, decide whether to include totals, hidden rows, or values from more than one column.

Step-by-Step

  1. Identify the data to compare. Find the column or row containing the values and note its first and last data cells. Exclude a heading such as “Price” or “Score.” If the list is in A2 through A8, for example, the range is A2:A8. Make sure you are comparing the same kind of values; a list of dates, for instance, will return the earliest date, because Excel stores dates as numbers.
  2. Choose an empty result cell. Click a blank cell outside the data, such as B2 if the values are in column A. Keeping the answer separate from the source list makes it easier to read and prevents accidentally replacing a value you meant to include. If you put the result in a cell inside the range, the formula can create a circular reference.
  3. Enter the MIN formula. With the values in A2:A8, enter =MIN(A2:A8) in the empty result cell and press Enter. The formula uses the range between the parentheses, including both endpoints. In the example list 18, 7, a blank, 12.5, -3, 7, and 0, it returns -3. Negative numbers count as lower than zero, and decimal values are compared normally.
  4. Check the selected range. Click the formula cell and look at the formula bar. Confirm that the first and last references match the intended data and that the range includes every relevant row. A missing final row can produce a plausible-looking but incorrect answer. If the data is in another column, change the reference; for example, a list in C3:C25 needs that range rather than A2:A8.
  5. Use the formula bar or type directly in the cell. Either method works: select the result cell, type the formula beginning with an equals sign, and press Enter. You can also type =MIN(, select the cells with the mouse, type the closing parenthesis, and press Enter. Excel may display a suggested function while you type; choose MIN, not a similarly named function, if you want the smallest ordinary numeric value.
  6. Include separate ranges when needed. If values are in two nonadjacent columns, you can give MIN both ranges. With the first set in A2:A8 and the second set in C2:C8, enter =MIN(A2:A8,C2:C8). If the smallest values are -3 in the first range and -5 in the second, the result is -5. Use commas between arguments in standard English-language Excel; some regional settings may use a different list separator.
  7. Check whether the answer should update. MIN recalculates when a referenced value changes, provided calculation is set to Automatic. Test it by editing a source value only if it is safe to do so, then undo the edit. If you add new rows later, make sure those rows are included. A formatted Excel Table can make a growing list easier to maintain, but for a simple one-time check, a normal cell range is enough.

When the list is part of a larger worksheet, the same method applies to an entire column or a defined block of cells. Avoid selecting a whole column automatically if it contains unrelated numbers elsewhere; a focused range makes the result easier to verify and reduces the chance of including a note, subtotal, or other value by mistake.

Common Mistakes

Including the heading or the wrong rows: Text headings are generally ignored by MIN when they are in a referenced range, but including extra rows can still change the result if they contain numbers. Check the range rather than assuming the formula has selected the right data. If the smallest result seems unexpectedly low, look for an unrelated zero, negative number, or subtotal in the selected cells.

Expecting numeric-looking text to count: A cell that looks like 12 may actually contain text, perhaps because it was imported with a leading apostrophe or unusual characters. MIN ignores text in a cell reference, so that entry will not be considered as a number. Convert the affected cells to numbers before relying on the result; changing the display format alone does not always convert stored text.

Using the wrong idea of “lowest”: MIN checks all numeric cells in the references, not just the rows currently visible after filtering. It also does not find the lowest value for a particular category unless you use a conditional method. Decide whether you mean the lowest across the entire range, the lowest visible value, or the lowest value that meets a condition.

Putting the formula inside its own range: If the result cell is included in the range being evaluated, Excel may report a circular reference or fail to calculate as intended. Place the answer outside the source range, or adjust the range so it does not include the formula cell.

Ignoring an error in the source data: An error such as #N/A or #VALUE! in the referenced cells can cause MIN to return an error instead of a number. Find and address the source error rather than assuming MIN will skip it. This is different from a blank cell, which MIN normally ignores.

Tips

Use status-bar results for a quick check. Select a range and look at Excel’s status bar along the bottom of the window. Depending on your status-bar settings, it may show numerical summaries such as Average, Count, and Sum, but it does not always display Minimum by default. Right-click the status bar and enable Minimum if that option is available. This is useful for a quick look, while a formula is better when you want a saved, reusable answer.

Find the lowest visible value in a filtered list. MIN includes values hidden by a filter. If you want a subtotal-style result that responds to filtering, use SUBTOTAL instead. With values in A2:A20, enter =SUBTOTAL(5,A2:A20) to return the minimum of rows visible after filtering; for example, if the visible values are 8, 3, and 11, the result is 3. Function number 5 includes manually hidden rows, while 105 excludes manually hidden rows as well as filtered-out rows. With the same A2:A20 layout, =SUBTOTAL(105,A2:A20) returns the visible minimum while also excluding manually hidden rows. Neither version changes the source values.

Find a minimum for one category. In Microsoft 365 and Excel 2019 or later, MINIFS can return the minimum that meets a condition. With categories in A2:A20 and corresponding measurements in B2:B20, enter =MINIFS(B2:B20,A2:A20,"North") to find the lowest measurement for North. If North has measurements 14, 9, and 12, the result is 9. Ensure the category spelling in the data matches the criterion; leading or trailing spaces can prevent a match.

Make the answer easy to interpret. Label the result cell, such as “Lowest score,” and format it appropriately. If it represents a date, apply a date format so Excel shows a readable date rather than its underlying serial number. If the data changes regularly, keep the result beside the list or in a clearly labeled summary area.

Troubleshooting

The result is 0, but no zero appears in the list: Check whether the range includes blank-looking cells that contain a formula returning zero, or other cells with a stored zero. Also verify that you did not select a different range than intended. Ordinary empty cells alone do not make MIN return zero when the range contains positive numbers.

The result is too high or a number seems to be missing: Check for values stored as text. Select a suspicious cell and inspect the formula bar; if needed, use the warning icon that Excel displays for numbers stored as text and choose Convert to Number. You can also try Data > Text to Columns and complete the steps without changing the delimiter settings, but first make a copy if the imported data is important. After conversion, confirm that the displayed values and the MIN result are correct.

Excel displays an error or does not calculate: If you see a formula error, inspect the source range for errors and check that the parentheses and cell references are complete. If the cell displays the formula itself instead of a result, the cell may be formatted as Text; change it to General, then re-enter the formula. Also check Formulas > Calculation Options > Automatic. In Excel for the web and on Mac, the formula is the same, though ribbon arrangement can differ. On a Mac, press Return to confirm the entry; on Windows, press Enter.

The answer does not change after editing data: Confirm that the edited cell falls within the formula’s range. If it does, check Formulas > Calculation Options > Automatic. In Manual mode, press F9 on Windows to recalculate; on Mac, use Fn+F9 if the function keys are set to control hardware features, or use the calculation command available in Excel. Check whether the result cell contains a fixed number rather than a formula by selecting it and looking at the formula bar.

The filtered result still includes hidden rows: Verify that the formula uses SUBTOTAL with function number 5 or 105, not MIN. Use 105 if manually hidden rows must also be excluded. Remember that SUBTOTAL responds to filtered rows and hidden rows according to its function number; it does not restrict the calculation to a category unless you filter the data or use a suitable conditional formula.

Frequently Asked Questions

What is the formula for the lowest number in Excel?
Use MIN with the cells to compare. For example, if the values are in B2:B15, enter =MIN(B2:B15) in a different cell. Excel returns the smallest numeric value in that range.

Does MIN ignore blanks and text?
Yes. MIN ignores blank cells and text in referenced cells, so numbers stored as text may be skipped. Error values in the range can cause an error result, so correct them if needed.

Can I find the lowest number across multiple columns?
Yes. List each range as an argument, separated by a comma. Check that every range contains only the data you intend to compare; an unrelated low number in either range will affect the answer.

Does MIN update when I change a value?
Yes, when the changed cell is part of the referenced range and Excel is set to calculate automatically. If you append new data outside the range, edit the formula or expand the range so the new cells are included.

How do I find the lowest number in a filtered list?
Use SUBTOTAL with function number 5 for filtered rows, or 105 if manually hidden rows should be excluded too. MIN does not ignore filtered-out rows.

Can I find the lowest value that meets a condition?
Yes. Use MINIFS in Excel 2019 or Microsoft 365, specifying the values range, the criteria range, and the condition. Check that the condition matches the data and that the values range contains numbers.

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.