How to Find the Minimum in Excel Using the MIN Function

To find the smallest number in a range, use Excel’s MIN function. If your values are in cells B2 through B10, enter =MIN(B2:B10) in an empty cell and press Enter. For example, if the range contains 18, 7, 24, 3, 11, 9, 15, 6, and 12, the result is 3. You need a workbook with numeric data and a blank cell for the answer.

What You’ll Need

Microsoft Excel for Microsoft 365 on Windows. The steps also work in recent desktop versions of Excel; Excel for the web has the same MIN function, though ribbon placement can differ slightly.
A range of cells that contains the values you want to compare. The values can be in a row or a column.
An empty cell where you can display the result. If you want to keep the original data unchanged, place the result outside the data range.

Step-by-Step

Identify the values to compare. Look at the column or row containing your numbers and note the first and last cells. For instance, if monthly costs are in cells B2 through B10, the range is B2:B10. Do not include a heading such as “Cost” unless you have a specific reason; MIN ignores text in a referenced range, but selecting just the data makes the formula easier to understand and check. If your values are spread across separate areas, note each area before entering the formula.
Select an empty cell for the answer. Click a blank cell outside the data, such as D2. Avoid putting the result inside the range being evaluated: including the formula cell in its own range can create a circular reference or make the calculation unclear. You can put the answer above or below the list, or on another worksheet if that is more convenient.
Enter the MIN formula. With the numbers in B2:B10, type =MIN(B2:B10) in the selected cell and press Enter. Excel displays the smallest numeric value from that range. The formula begins with an equals sign, MIN is the function name, and the cell range appears inside parentheses. You can type the formula directly or start with =MIN(, select the range with your mouse, type the closing parenthesis, and press Enter.
Check that the answer makes sense. Compare the result with the values in the source range. In the example list from the introduction, the smallest value is 3, so the formula should return 3. If the number appears as a date, currency, or percentage, the underlying result may still be correct but formatted in an unexpected way. Select the result cell and use Home > Number Format to choose an appropriate display format.
Use AutoSum if you prefer the ribbon. Select an empty cell immediately below a vertical list or to the right of a horizontal list. On the Home tab, in the Editing group, open the AutoSum drop-down and choose Min. Check the range Excel highlights before pressing Enter. AutoSum can guess the intended range from nearby data, but it may include a heading, omit a value, or select the wrong block if there are blank rows or adjacent columns.
Include multiple ranges when needed. MIN can compare separate ranges in one formula. With values in B2:B10 and D2:D10, enter =MIN(B2:B10,D2:D10) in an empty cell. Excel returns the lowest number found in either range. The comma separates the arguments. You can also select individual cells, but using clear range references is generally easier to maintain.
Adjust the range as your data changes. A formula such as =MIN(B2:B10) does not automatically expand if you add a new value in B11. Update the reference to include the new cell, or convert the list into an Excel table so references can grow with the table. To make a table, select the data and choose Insert > Table, then confirm whether your data has headers. For recurring reports, a table can reduce the chance of accidentally leaving new entries out of the calculation.
Find a minimum that matches a condition, if required. If you need the smallest value only for one category, use MINIFS rather than MIN. With regions in A2:A20 and corresponding sales amounts in C2:C20, enter =MINIFS(C2:C20,A2:A20,"North") to return the smallest sales amount for rows labeled North. For example, if North has sales of 42, 18, and 35, the result is 18. MINIFS is available in Microsoft 365 and newer Excel versions, including Excel 2019. Make sure the values range and criteria range cover the same rows.

MIN works with numbers stored as numeric values, including dates and times, which Excel stores as serial numbers. It ignores blank cells and text in a referenced range. A zero is a number, however, so it can become the minimum. That behavior is useful for many lists, but it matters if zero means “not entered” in your data.

Common Mistakes

Selecting the wrong range: A formula can calculate correctly while still answering the wrong question. If you leave the final rows out, Excel cannot consider them. If you include unrelated numbers in a neighboring column, the result may be unexpectedly small. Click the formula cell and inspect the colored range outline, or edit the range shown in the formula bar.

Expecting MIN to ignore zero: MIN treats zero as a valid number. If a range contains 0, 4, and 9, the minimum is 0. If zero represents missing information, correct or flag those entries before calculating, or use a criteria-based approach that deliberately excludes zero. Do not exclude zeros automatically if they are genuine measurements.

Confusing numbers stored as text with numbers: A value that looks like 12 may be text rather than a numeric value. MIN generally ignores text in a cell reference, so it may return a larger number or act as if the entry is absent. A green triangle, left alignment, or an apostrophe before the value can be a clue, although formatting alone is not conclusive.

Including the answer cell in its own range: If the formula is in B11, a range of B2:B11 includes the result cell itself. Use B2:B10 instead, or place the result in a separate column. A circular reference warning means Excel cannot resolve a formula that depends on its own result.

Assuming filtered rows are excluded: MIN evaluates the referenced cells even when some rows are hidden by a filter. If you want the minimum among visible rows only, use SUBTOTAL with the appropriate function number. With amounts in B2:B20 and a filter applied to the rows, enter =SUBTOTAL(105,B2:B20) to calculate the minimum while excluding filtered-out and manually hidden rows. The result will change as the visible set changes.

Tips

Use a clear label. Add a nearby label such as “Lowest value” so another person can tell what the result represents. Keep the label outside the numeric range used by MIN.
Format the answer to match the data. If the source values are dates, format the answer as a date; if they are currency, use a currency format. Number formatting changes how a value appears, not the value MIN calculates.
Use a table for expanding lists. Excel tables make it easier to add rows without overlooking new values in a calculation. After creating a table, you can use its column name in a formula; Excel inserts the structured reference when you select the column.
Use the status bar for a quick check. Select the numeric cells and look at the status bar at the bottom of the Excel window. If Minimum is not displayed, right-click the status bar and select Minimum. This is a quick way to inspect a selection, but it does not put a reusable answer into a worksheet cell.
Keep the formula simple when possible. MIN is usually the clearest choice for one straightforward range. Use MINIFS for criteria and SUBTOTAL for a visible-rows-only calculation, rather than building a more complicated formula without a need.

Troubleshooting

The result is 0, but you expected a positive value. Check the range for a real zero, a formula that returns zero, or an entry that should not be included. If zero is a valid measurement, the result is correct. If it means missing data, decide how your worksheet should represent missing values before changing the calculation.

The result is larger than the smallest value you can see. The apparent minimum may be stored as text, or it may be outside the formula’s selected range. Click the suspected cell and inspect the formula bar. To convert a text number, select the affected cells and, if Excel offers the warning icon, choose Convert to Number. You can also use Data > Text to Columns and complete the wizard without changing the delimiter settings, but check a copy of the data first if it contains mixed formats.

Excel shows a formula instead of an answer. Confirm that the entry begins with an equals sign and that the cell is not formatted as Text. Change the cell format to General, then re-enter the formula by pressing F2 and Enter. Also check whether Show Formulas is enabled on the Formulas tab; turning it off returns the sheet to its normal results view.

The formula returns 0 when there are no numeric entries. MIN returns 0 when its arguments contain no numbers. Check that the selected cells contain actual numeric values and that your range is correct. If the worksheet needs to distinguish “no data” from a genuine minimum of zero, add a separate check for numeric entries or show a clear message rather than interpreting 0 as a real measurement.

AutoSum chooses the wrong cells. Cancel or undo the inserted formula, select the intended result cell again, and enter the range yourself. This is especially useful if the list has blank rows, totals, or neighboring data that AutoSum might mistake for part of the list.

Frequently Asked Questions

What is the Excel formula for the smallest number?
Use MIN. For values in A2:A15, enter =MIN(A2:A15) in a blank cell. The function returns the smallest numeric value in that range.

Does MIN count blank cells or text?
No. MIN ignores blank cells and text in a referenced range. It does count zero and other numeric values. A number stored as text may be ignored, so convert it to a real number if it should be part of the calculation.

Can MIN find the smallest value across different columns?
Yes. Separate ranges with commas in the function. For example, =MIN(A2:A10,C2:C10) compares values in both ranges and returns the smallest number across them.

How do I find the lowest value for one category?
Use MINIFS when your Excel version supports it. Set the first argument to the values to compare and the next arguments to the criteria range and condition. For example, the North-region example above returns the minimum sales amount for North.

Can Excel show the minimum in a filtered list?
MIN includes filtered-out rows. Use =SUBTOTAL(105,B2:B20) when the amounts are in B2:B20 and you want the minimum among visible rows, excluding both filtered-out and manually hidden rows.

Can I find the smallest value without putting a formula in the sheet?
Yes. Select the cells and enable Minimum on the status bar by right-clicking the bar at the bottom of the Excel window. The value is a quick check, but a formula is better when you want the result saved, referenced, or updated as part of the worksheet.

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.