With the two numeric values in cells A2 and B2, enter =MIN(A2,B2) in the cell where you want the answer. Excel returns whichever value is smaller; if the values are equal, it returns that shared value.
What the MIN formula does
MIN is Excel’s built-in function for finding the lowest number in a set. Its simplest form takes two cell references separated by a comma, but it can also compare more values or a range. For the common two-cell comparison, it is usually the clearest choice: the formula says directly that you want the minimum of the two entries.
The function compares numeric values, not their positions or labels. If A2 contains 18 and B2 contains 11, the result is 11. It does not tell you whether that result came from A2 or B2; it returns the value itself. If you need to identify the source as well as show the lower number, you will need an additional formula or a separate label column.
MIN works with ordinary numbers, decimals, percentages, and dates because Excel stores those as numbers. For example, when two cells contain valid dates, the earlier date has the lower underlying serial number, so MIN returns the earlier date value. Make sure the result cell is formatted appropriately: a date result displayed as a large number may simply need a date number format.
A worked example with two values
Suppose A2 contains 24.5 and B2 contains 19.75, and you want the lesser value in C2. With those values in A2 and B2 and C2 as the result cell, enter =MIN(A2,B2). The result is 19.75, because 19.75 is less than 24.5.
You can also compare values entered directly in a formula, although cell references are generally easier to maintain when the inputs may change. For a fixed comparison of 24.5 and 19.75, enter =MIN(24.5,19.75); the result is again 19.75. If either source value changes in the cell-reference example, Excel recalculates the result automatically.
To use the formula in a worksheet:
- Enter the first value in A2 and the second value in B2.
- Select C2, or whichever cell should display the lower value.
- Type the formula and press Enter.
- Check that the result is the smaller of the two inputs, then format the result cell if needed.
Compare two values down a list
The same approach is useful when each row has a pair of values, such as two supplier quotes or two measurements. Put the first set in A2 and B2, then place the result in C2. With that row layout, enter =MIN(A2,B2). To compare the next row, copy the formula from C2 to C3. Excel adjusts the relative references so the copied formula compares A3 with B3.
On Windows, you can drag the fill handle—the small square at the lower-right corner of the selected cell—down the result column. On Mac, the fill handle works in the same way. You can also copy and paste the formula into the destination cells. Check the first few results after filling: a misplaced column or an unexpected blank can make a correctly written formula give a result you did not intend.
For example, if A2:B4 contains pairs 12 and 9, 4 and 7, and 15 and 15, the results are 9, 4, and 15. The middle row is a useful reminder that the formula is not always returning the value from the same column. It chooses the lower number independently for each row.
MIN compared with an IF formula
You could also compare two numeric cells with IF. With A2 and B2 holding the two values and C2 holding the result, enter =IF(A2<B2,A2,B2). This returns A2 when A2 is less than B2; otherwise, it returns B2. For ordinary numeric comparisons, it gives the same lesser value as MIN.
MIN is usually simpler when the only goal is to return the lower number. IF is useful when the outcome needs a condition or a custom message. For instance, you might want a result such as “Review” when one value is missing, or you might need to apply a rule before returning a value. Keep in mind that an IF comparison has its own behavior for text and blanks, so it is not automatically a safer replacement for MIN.
When the values are tied, the IF version above returns B2 because the test A2<B2 is false when both are equal. The displayed number is still the same either way. If you are trying to return an associated item—such as the name of the supplier with the lower quote—design the formula to handle ties explicitly if the distinction matters.
What happens with blanks, text, and errors
MIN has behavior that is important when a worksheet is incomplete or its inputs are not truly numeric. When cell references are supplied, MIN ignores blank cells and text entries. If A2 contains 8 and B2 is empty, a formula comparing those cells returns 8; the blank is not treated as zero. This is often helpful when a blank means “not entered yet,” but it can be surprising if you expect an empty cell to count as the smallest value.
Text that looks like a number can also be skipped when it is stored as text in a referenced cell. For example, a cell containing the text “6” is not necessarily treated like the numeric value 6. If both referenced cells contain no numeric values—because they are blank or text—MIN returns 0. An error value in either referenced cell, by contrast, generally causes the formula to return an error rather than silently choosing the other value.
Before relying on a result, decide what each nonnumeric entry means in your data:
- If a blank means “no value supplied,” ignoring it may be appropriate, but consider whether a result based on just one available value could mislead someone.
- If a blank should count as zero, convert or handle that input explicitly rather than assuming MIN treats it as zero.
- If a number is stored as text, convert it to a genuine number when practical. Excel may show a warning indicator for some values stored as text; the exact indicator depends on the data and settings.
- If an error appears, inspect the source cells and fix the underlying error before trusting a comparison.
For a report that should remain empty until both inputs are supplied, an explicit blank check can make the rule clear. With inputs in A2 and B2 and the answer in C2, enter =IF(OR(A2="",B2=""),"",MIN(A2,B2)). This displays an empty result if either cell is empty or evaluates to an empty string; otherwise, it returns the lower value. Use this only when withholding the result until both entries exist is the intended behavior.
Negative numbers, zero, decimals, and ties
MIN compares numbers by their numeric size, including values below zero. If one input is -3 and the other is 2, the lesser value is -3. A negative value is not automatically an error; it may be expected for temperatures, account adjustments, or measurements relative to a baseline. Likewise, zero is a normal number and is lower than any positive number but higher than any negative number.
Decimal comparisons are also numeric, not based on how many digits are displayed. A cell formatted to show one decimal place might display both 2.04 and 2.03 as 2.0, while MIN still compares their stored values and returns 2.03. If two results appear identical on screen, increase the displayed decimal places or inspect the formula bar before concluding they are equal.
If both inputs have exactly the same numeric value, MIN returns that value. It does not flag a tie or tell you that two cells matched. If detecting a tie matters, add a separate comparison rule or conditional formatting rather than expecting the minimum formula to communicate that extra information.
Compare more than two values or use a range
Although the question is about two values, the same function scales naturally. With values in A2, B2, and C2 and the answer in D2, enter =MIN(A2,B2,C2) to return the lowest of the three. You can add further cell references as needed.
When the candidates are together, a range is often easier to read. With the values in A2:C2 and the result in D2, enter =MIN(A2:C2). For values listed vertically in A2:A10, put the result in B2 and enter =MIN(A2:A10). The colon means the range includes all cells from the first reference through the last.
Do not include the result cell itself in the range being evaluated. For example, putting a minimum formula in A11 and asking it to evaluate A2:A11 creates a circular reference, because the formula depends on its own result. Use a range that contains only the candidate values, such as A2:A10.
Common mistakes and quick checks
A comma separates function arguments in the English-language formula examples here. Some Excel installations use a different list separator because of regional settings. If Excel rejects a formula with a comma, check the separator expected by your installation rather than changing the logic. The function itself is available in Microsoft 365 for Windows and does not require a newer dynamic-array function.
Another common misunderstanding is expecting MIN to return the lesser of two displayed strings. It is designed to find a numeric minimum; it is not a general-purpose way to choose the alphabetically earlier text. If the cells contain product names, status words, or numbers stored as text, first define the comparison rule you want and prepare the data accordingly.
When the answer seems wrong, check these points in order:
- Confirm that the formula refers to the intended two cells, not neighboring cells.
- Check whether either input is blank, an error, or a number stored as text.
- Look at the underlying values, not only rounded or formatted displays.
- Confirm that the result cell’s number format is suitable for the data.
- For a copied formula, verify that the references shifted to the intended row.
These checks separate formula problems from data and display problems. In many cases, the formula is calculating consistently, but the cell contents or number format do not match the assumptions behind the comparison.
Frequently Asked Questions
What is the formula for the lesser of two numbers in Excel?
With the numbers in A2 and B2, enter =MIN(A2,B2) in the result cell. Excel returns the lower numeric value.
Does MIN return zero when one cell is blank?
No. When you give MIN cell references, it ignores a blank cell and compares the numeric values that are present. If both referenced cells contain no numbers, the result is 0.
How do I return the greater of two values instead?
With the two values in A2 and B2, enter =MAX(A2,B2). MAX returns the larger numeric value, while MIN returns the smaller one.
Can MIN compare more than two cells?
Yes. With candidate values in A2:C2, use =MIN(A2:C2) to return the lowest value in that range. You can also provide multiple cell references as separate arguments.
Why does my result look wrong when the cells show the same number?
The displayed values may be rounded, or one input may be stored as text rather than as a number. Increase the displayed decimal places and check the cell contents. MIN compares numeric values, not just the characters visible on the worksheet.
Related
- Excel Data Validation Restrictions and Their Limits
- Data Validation Process: Steps, Checks, and Best Practices
- Data Validation Named Range in Excel: Setup and Fixes
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel MIN Without Blanks: What the Formula IgnoresIf your values are in A2:A10, use =MIN(A2:A10) to find the smallest number while ignoring blank cells. Excel’s…
- Excel Days Until Formula: Calculate a CountdownTo calculate calendar days until a date in Excel, put the target date in A2 and enter =A2-TODAY()…
- Excel INDIRECT Function: Reference Another SheetYes. In Excel, INDIRECT can turn a text string containing a worksheet reference into a usable reference. For…
- Excel Sum Positive Values Only: Formulas and ExamplesTo sum only positive values in Excel, use SUMIF with the criterion ">0". If the numbers are in…
- Excel Day of Week from Date: Formulas and FormattingIf your date is in A2, enter =TEXT(A2,"dddd") to show its full weekday name; for example, an actual…
- EDATE in Excel: Add or Subtract Months from a DateIn Excel, EDATE returns a date that is a specified number of months before or after a starting…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.