In Excel for Microsoft 365, use =MIN(B2:B10) to return the smallest numeric value in cells B2 through B10. Replace that range with the cells containing your data; MIN ignores blank cells and text in a referenced range, but it counts zero and negative numbers.
What MIN does in Excel
MIN is a built-in statistical function for finding the lowest number in a set of values. It is useful for checking the smallest sale, shortest duration, lowest score, earliest date, or minimum measurement in a worksheet. The function returns one value, rather than sorting the data or identifying the cell where that value appears.
For example, if a range contains 14, 9, 22, and 6, MIN returns 6. If the values include a negative number, that number can be the minimum: among 14, 9, -3, and 6, the answer is -3. This is ordinary numeric ordering, so a value does not have to be positive to be returned.
MIN evaluates values in the cells or arguments you give it. It does not change the source data. If you need to show which item has the lowest value, you need an additional lookup or a sort; MIN by itself only returns the value.
MIN syntax and arguments
The function’s syntax is MIN(number1, [number2], ...). The first argument is required, and later arguments are optional. An argument can be a number, a cell reference, a range, or a named range. You can supply multiple ranges or individual numbers, separating arguments with commas in standard Excel formulas.
For most worksheets, one range is enough. A range such as B2:B10 includes all cells from B2 through B10. You can also pass separate ranges, for example when figures are in different parts of a sheet. If you enter individual values directly as arguments, separate them with commas. Excel permits up to 255 arguments in a function call.
The brackets in the syntax indicate optional arguments; do not type those square brackets into the formula. If Excel displays a formula error as you enter it, check that the opening and closing parentheses match and that the range reference uses a colon between its first and last cells.
Find the minimum in a range
Suppose monthly amounts are in B2:B7. With those values in that range, enter =MIN(B2:B7) in an empty cell. If the cells contain 18, 12, a blank, 0, -4, and the text n/a, the result is -4. The blank and text entry do not count as numbers, while zero does count; the negative value is smaller than all the other numeric entries.
To use the function in a worksheet:
- Select the cell where you want the answer to appear.
- Type an equals sign followed by MIN and an opening parenthesis.
- Select or type the range to evaluate, such as B2:B7.
- Type the closing parenthesis and press Enter.
You can also type =MIN(, select cells with the mouse, and then finish the formula. Excel displays the selected reference as you work. When values in the source range change, the result recalculates automatically unless the workbook is set to manual calculation.
How MIN treats blanks, text, and zeros
MIN has a distinction that can explain results that seem surprising: values in a referenced range are not treated exactly like values typed directly into the function. In a cell reference or range, MIN ignores blank cells, text, and logical values such as TRUE and FALSE. A number stored as text in a cell is also not treated as a numeric value by MIN. By contrast, numeric values entered directly as function arguments can be evaluated, including logical values and numeric text.
Zero is a number, not a blank, so MIN includes it. This matters in schedules and reports where zero may mean a genuine result, while an empty cell means no result has been entered. If you want to exclude zero, MIN alone is not the right operation; use a conditional minimum such as MINIFS or prepare a suitable range for analysis.
MIN ignores text entries in the range rather than converting them to numbers. If numeric-looking entries are stored as text and should count, convert them to actual numbers first. You can often identify this issue by checking cell alignment, warning indicators, or whether arithmetic behaves as expected; formatting a text value as a number does not necessarily convert its underlying value.
Find the smallest value that meets a condition
When you need the minimum only for records that meet a condition, use MINIFS in Excel versions that include it, such as Microsoft 365, Excel 2019, Excel 2021, and Excel 2024. MINIFS takes a range to minimize, followed by a criteria range and condition. It is useful for questions such as the lowest price for one product category or the smallest result for a particular location.
For example, suppose locations are in B2:B6, amounts are in C2:C6, and E2 contains East. If the amounts for East are 18, 12, and 15, and the other rows are for different locations, enter =MINIFS(C2:C6,B2:B6,E2). The result is 12. The criteria range and the minimum range should cover corresponding rows so each amount is tested against the location on the same row.
MINIFS can also use a condition typed into the formula, but putting a condition in a cell makes it easier to change or reuse. It supports multiple criteria-range and criteria pairs, allowing you to restrict the result by more than one condition. If no records meet the criteria, MINIFS returns 0, so distinguish that result from a genuine zero in the source data when interpreting a report.
Use MIN with dates and times
Excel stores dates and times as numeric values, so MIN can find the earliest date or time in a range. For example, if A2:A5 contains April 3, April 1, a blank, and April 8, 2026, enter =MIN(A2:A5). The result is the date April 1, 2026, provided the cells contain real Excel dates rather than text that only looks like a date.
The result may initially appear as a serial number instead of a date. The calculation can still be correct: select the result cell and apply a date format from Home > Number. Choose a date display that suits the worksheet. If you are finding the earliest time, format the result as a time; the underlying minimum is still a numeric value.
If dates are stored as text, MIN may ignore them, leaving a later numeric date as the apparent minimum or returning zero if there are no numeric entries. Converting the source values to real dates is more reliable than changing only their display format. A format changes how a value looks; it does not always change the value Excel stores.
Common MIN problems and how to check them
A result of 0 does not always mean that a cell in the range contains zero. MIN returns 0 when its arguments contain no numbers to evaluate, and zero may also be the true smallest number in the range. Check the source cells, including whether apparent numbers or dates are stored as text, before deciding which explanation applies.
An error value inside a referenced range can cause MIN to return an error rather than skip that entry. Find and resolve the error in the source data, or use an appropriate error-handling approach if errors are expected. Do not assume that MIN treats errors like text: text in a range is ignored, but errors can propagate through the calculation.
Other checks that often resolve unexpected results include:
- Confirm the range: make sure the reference includes all intended rows and does not include an unrelated value.
- Check for hidden data: hiding a row does not make its value irrelevant to MIN; the function evaluates the referenced cells whether or not their rows are visible.
- Look for text-formatted numbers: convert entries that should be numeric, rather than relying on their appearance.
- Check calculation settings: if source values changed but the displayed result did not, confirm that calculation is set to Automatic under Formulas > Calculation Options.
A formula that returns an unexpected value can also be a correct answer to the range it was given. Inspect the formula bar or select the result cell to see its exact references, then compare those references with the intended dataset.
MIN compared with related functions
MIN is different from MAX, which returns the largest numeric value. They are useful together for checking the range of a dataset, but neither function explains how often a value occurs or which record contains it. If the second-smallest value is needed, SMALL is more suitable: it accepts a range and a rank, such as 1 for the smallest or 2 for the second smallest.
MINA is another related function, but it treats logical values and text differently from MIN when they are part of referenced data. In particular, MINA evaluates TRUE as 1, FALSE as 0, and text as 0 in a reference. For ordinary numeric data, MIN is usually the simpler choice; use MINA only when that treatment of logical or text entries is intended.
MINIFS answers a different question from MIN: it finds the minimum among values that satisfy specified criteria. Use MIN when every numeric value in the chosen range is eligible. Use MINIFS when the minimum should be limited by a category, date, status, or other condition. If your Excel version does not provide MINIFS, a formula using other functions may be needed, depending on the version and the exact criteria.
Frequently Asked Questions
Does MIN in Excel ignore blank cells?
Yes. Blank cells in a referenced range are ignored. If the range has no numeric values, MIN returns 0, so verify that the range contains the values you expect.
Does MIN count zero?
Yes. Zero is a numeric value, so it can be the smallest result. MIN does not treat zero as a blank or automatically exclude it.
Why does MIN return 0 when my cells look like numbers?
The entries may be stored as text, or the selected range may contain no numeric values. Convert text-formatted numbers to real numbers and check that the formula points to the intended cells.
Can MIN find the earliest date?
Yes, because Excel stores valid dates as numbers. Apply a date format to the result if it appears as a serial number, and make sure the source dates are real date values rather than text.
How do I find the smallest value for one category?
Use MINIFS when available. Provide the numeric range to evaluate, the range containing category labels, and the category to match; the ranges should line up row by row.
Does MIN show which cell contains the lowest value?
No. MIN returns the minimum value only. To identify the matching row or item, pair the result with a lookup or another method that returns the associated record.
Related
- Supplier Contact List Template in Excel: Fields and Setup
- Supply List Excel Template: How to Build and Use One
- Excel Superscript Shortcut: Apply Superscript to Text
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Regression Analysis Output: What Each Statistic MeansExcel regression output summarizes how well a linear model fits your data and how each predictor relates to…
- Lock Track Changes in Word Online: What You Can DoYou can’t password-lock Track Changes directly in Word for the web. To make sure collaborators can’t turn tracking…
- Google Sheets Duplicate Formula: Find or Flag RepeatsTo find duplicate values in Google Sheets, use =COUNTIF($A$2:$A$100,A2)>1 in a helper column, assuming the values are in…
- Excel Dropdown List Examples and How to Create ThemExcel dropdown lists let people choose from approved entries instead of typing them by hand. In Microsoft Excel…
- How to Sum a Column in the Google Sheets Mobile AppTo sum a column in Google Sheets on your phone or tablet, tap an empty cell where you…
- Join Two Sheets in Google Sheets: Methods That WorkTo join two sheets in Google Sheets, decide whether you need to stack their rows, match records using…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.