Minimum in Excel: Find the Smallest Value in a Range

How-to basics · Updated November 22, 2026

In Excel, the minimum is the smallest numeric value in a set of values. To find it, put the values in B2:B10 and enter =MIN(B2:B10); Excel returns the lowest number in that range.

What “minimum” means in Excel

“Minimum” describes a result, not a special kind of cell or a separate Excel setting: it is the least value among the values being compared. If a list contains 14, 6, 21, and 9, its minimum is 6. The maximum is the greatest value, while the minimum is the least. In Excel, the MIN function is the usual way to calculate that result.

A minimum depends on which cells you include and what those cells contain. A zero can be the minimum even if the other values are positive. A negative number is smaller than zero, so -4 is the minimum of -4, 0, and 3. In a date list, the earliest valid date is the minimum because Excel stores dates as numbers. These details matter when a result seems unexpected: Excel may be finding the minimum correctly, but the range or the data may not match what you intended to compare.

How the MIN function works

MIN takes one or more numbers, ranges, or references and returns the smallest numeric value among them. The simplest form is =MIN(number1, [number2], ...). The square brackets in this general description indicate an optional argument; do not type them into the formula. A range is often the clearest choice because it automatically includes new numeric values added within that range.

With test scores in C2:C8, for example, the formula =MIN(C2:C8) returns the lowest score in those cells. You can also compare separate ranges. With morning readings in B2:B5 and afternoon readings in D2:D5, =MIN(B2:B5,D2:D5) returns the lowest numeric reading across both ranges. The ranges do not have to be next to each other.

MIN returns a value, not the location of the cell that contains it. If two or more cells tie for the minimum, MIN still returns just that value. To identify which record has that value, you need an additional lookup or a filtering step; the MIN result alone does not tell you which row supplied it.

Examples with numbers, dates, and ranges

Suppose B2:B6 contains 18, 12, 0, 25, and 9. With those figures in B2:B6, enter =MIN(B2:B6). The result is 0 because zero is included and is lower than every positive number in the list. If the zero represents missing data rather than a real measurement, a plain MIN formula will not know that; you must define an appropriate rule for excluding it.

MIN works with actual Excel dates as well as ordinary numbers. If A2:A20 contains valid dates, =MIN(A2:A20) returns the earliest date. The result may initially appear as a serial number if the result cell is formatted as General or Number. Apply a date format through Home > Number Format to display it as a calendar date. Dates stored as text may not be treated as dates, so check that imported values are genuine Excel dates.

You can also enter individual values directly, such as =MIN(8,3,11), which returns 3. For a changing list, however, referencing worksheet cells is usually more practical: the formula can recalculate when the data changes, and the data remains easier to inspect and update.

How blanks, text, zeros, and errors are treated

When MIN refers to a range, it ignores blank cells, text, and logical values such as TRUE and FALSE. It does not treat those cells as zero. That behavior is useful when a column mixes numbers with labels or has empty cells, but it can also hide data-quality issues. For instance, a price imported as text may be skipped even though it looks like a number on the worksheet.

Zero is different from a blank: it is a number and is included in the calculation. Negative numbers are included too. If the supplied arguments contain no numeric values, MIN returns 0, which can be indistinguishable from a genuine minimum of zero unless you check the source data or add a separate test for whether numeric values exist.

An error in a referenced range can cause the MIN formula to return an error rather than a minimum. Find and correct the source error, or handle it deliberately before calculating. Avoid wrapping a formula in error-handling logic merely to make the displayed result look clean: that can conceal a problem in the underlying data.

Finding a minimum that meets a condition

Use MINIFS when you want the smallest value only among rows that meet one or more conditions. It is available in Excel for Microsoft 365 and Excel 2019 or later. Suppose A2:A7 contains region names and B2:B7 contains amounts. If the North rows have amounts 12, 8, and 15, then with regions in A2:A7 and amounts in B2:B7, enter =MINIFS(B2:B7,A2:A7,"North"). The result is 8, the smallest amount for North.

MINIFS takes the values to compare first, followed by a criteria range and its condition. You can add more criteria-range and condition pairs. For example, a list of regions and product types can be used to find the lowest amount for a particular region and product together. The criteria ranges should correspond row by row with the minimum range so each condition applies to the intended record.

A common use is to exclude zero values when zero means “not recorded.” With measurements in B2:B10, =MINIFS(B2:B10,B2:B10,">0") returns the smallest positive value. This is a rule you choose, not a general definition of minimum: if zero is a valid measurement, excluding it would produce the wrong answer. If no values meet the criteria, MINIFS returns 0, so consider how to distinguish “no match” from a genuine zero in your worksheet.

Show the minimum on the worksheet

To highlight the lowest value visually, select the cells you want to format, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. If the selected range is B2:B10, enter =B2=MIN($B$2:$B$10) in the rule’s formula box, choose a format, and confirm. The relative B2 reference adjusts for each cell, while the dollar signs keep the comparison range fixed. Every tied minimum in the selected range will be highlighted.

This rule changes the appearance of matching cells; it does not place the minimum in a separate result cell. Use the MIN formula in a cell when you need a result for another calculation, chart, or report. Conditional formatting is useful when the goal is to spot the lowest entry in the original list without sorting or changing the data order.

Common problems and useful checks

  • The result is zero: Check whether the range contains a real zero, whether it contains any numeric values at all, and whether a conditional minimum has any matches.
  • A number seems to be skipped: The cell may contain a number stored as text. Check its format and convert the value to a number if appropriate; changing the display format alone does not always convert text into numeric data.
  • The result is unexpectedly low: Look for negative numbers, zeros, or cells included unintentionally in the range. Confirm that the formula covers only the intended rows and columns.
  • The result shows as a serial number: If the values are dates, format the result cell as a date rather than assuming the formula is wrong.
  • The formula returns an error: Inspect the referenced cells for errors and verify that the formula’s ranges and parentheses are correct.

When entering a formula in Microsoft Excel for Microsoft 365 on Windows, type it in a cell and press Enter. Excel for Mac uses the same MIN function and formula syntax; some ribbon layout details can differ. In Excel for the web, the formula is also supported, though the available interface may vary slightly from the desktop app.

MIN compared with related options

MIN is usually the right choice for the smallest numeric value in a range. MINA is a different function: it includes logical values and text in references under its own rules, treating TRUE as 1, FALSE as 0, and text as 0. That makes MINA inappropriate as a drop-in replacement when you simply want to ignore labels and logical entries. Check the source data and the intended treatment before choosing between them.

If you need the lowest value among rows that meet a condition, MINIFS is more direct than first rearranging or manually filtering the data. If you need the minimum visible in a filtered list, SUBTOTAL can be useful. With values in B2:B10, =SUBTOTAL(5,B2:B10) calculates a minimum while excluding rows removed by a filter; function number 5 does not exclude rows hidden manually. Use =SUBTOTAL(105,B2:B10) when manually hidden rows should also be excluded. Unlike MIN, SUBTOTAL is designed to respond to filtered rows.

Sorting the data from smallest to largest is another way to inspect the low end of a list, but it changes the displayed order and does not provide a live minimum result in a separate cell. Use MIN for a simple calculation, MINIFS for criteria, conditional formatting for visual emphasis, and SUBTOTAL when the filtered or hidden-row behavior is part of the requirement.

Frequently Asked Questions

What is the formula for the minimum in Excel?
Use MIN with the range to compare. If the values are in A2:A20, enter =MIN(A2:A20) in another cell. The formula returns the smallest numeric value in that range.

Does MIN in Excel ignore zero?
No. Zero is a number, so MIN includes it. If zero should not count for your particular task, use an explicit condition, such as MINIFS with a greater-than-zero criterion, and make sure excluding zero matches the meaning of your data.

Does MIN include blank cells?
Blank cells in a referenced range are ignored; they are not treated as zero. Text and logical values in a referenced range are also ignored by MIN, while numeric zeros and negative numbers are included.

How do I find the minimum value for one category?
Use MINIFS with the numeric range and the category range. For example, if categories are in A2:A20 and values in B2:B20, =MINIFS(B2:B20,A2:A20,"North") returns the minimum value for rows labeled North.

Can MIN return the cell containing the smallest value?
Not by itself. MIN returns the smallest value, not its address or row. If you need the corresponding label or record, use a separate lookup approach and consider how to handle ties, where more than one row can share the minimum.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.