Excel Formula for the Lower of Two Values in Two Cells

Formulas & functions · Updated November 18, 2026

To return the lower of two values in Excel, use =MIN(A2,B2). If the values are in cells A2 and B2, the formula returns whichever number is smaller; for example, if A2 is 18 and B2 is 12, the result is 12.

The Basic MIN Formula

MIN is Excel’s built-in function for finding the smallest numeric value among its arguments. With the two values in A2 and B2, enter =MIN(A2,B2) in another cell, such as C2. In the example where A2 contains 18 and B2 contains 12, C2 displays 12. The formula refers to the original cells, so if either value changes, Excel recalculates the result.

The comma separates the two arguments: the first cell and the second cell. You can use other cell references, including cells on another worksheet, as long as the references point to the values you want to compare. If the values are typed directly into the formula, the layout is not relevant; for example, =MIN(18,12) returns 12. Cell references are usually more useful because the result updates when the input values change.

For a simple comparison of two numbers, MIN is usually the clearest choice. It is short, easy to read, and also works if you later need to compare more than two values.

How MIN Chooses the Lower Value

MIN compares numeric values and returns the smallest one. It does not change the cells being compared or indicate which cell supplied the result; it returns the value itself. If both cells contain the same number, the result is that number. For instance, if both A2 and B2 contain 7, the result is 7, not a message that the values are tied.

With values in A2 and B2, =MIN(A2,B2) returns the lower number whether the first value is larger or the second is larger. The order of the references does not affect the answer. You can also give MIN a range, which is handy when a comparison grows beyond two cells. If B2 through E2 contain 9, 4, 11, and 6, then =MIN(B2:E2) returns 4.

MIN compares the underlying numbers, not how the cells look. A number formatted as currency is still compared by its numeric value. Similarly, a percentage is stored as a decimal value, so 15% is represented numerically as 0.15. Formatting affects display, not which value MIN considers smaller.

Where to Put the Formula

Keep the two source values in separate cells and put the result in a third cell. For example, enter the amounts in A2 and B2, then enter the formula in C2. This avoids overwriting an input and makes the result easy to reference in other formulas, charts, or summaries.

  1. Enter the first value in A2 and the second value in B2.
  2. Select C2, or another empty cell where you want the answer.
  3. Type =MIN(A2,B2) and press Enter.
  4. Change either input to confirm that the result updates automatically.

In Excel for Microsoft 365 on Windows, the same formula can be entered directly in the formula bar or in the selected cell. Excel for Mac and Excel for the web use the same MIN syntax. If your regional Excel settings use semicolons as the list separator, Excel may require =MIN(A2;B2) instead of the comma version. The function name and comparison are the same; the separator depends on the settings.

When copying the formula down a list, ordinary references adjust by row. For example, copying a formula in C2 to C3 changes the references to A3 and B3. That behavior is useful when each row has its own pair of values.

MIN Compared with IF

MIN is not the only way to return the smaller of two values. An IF formula can test which value is lower and then return the appropriate cell. With the values in A2 and B2, enter =IF(A2<B2,A2,B2). If A2 is 18 and B2 is 12, the test is false and the formula returns B2, which is 12.

For simply returning the lower number, MIN is generally more concise. IF is useful when the result needs extra logic, such as returning a label or applying a different rule when the values are equal. In the example above, if the values tie, the condition A2<B2 is false and the formula returns B2. The displayed numeric result is still the same, but the choice of source cell can matter if you later build more logic around it.

MIN and IF can also behave differently when a cell is blank or contains text. MIN ignores text and empty cells referred to by cell references, while an IF comparison can treat a blank as zero in a numeric comparison. Choose based on the data you have and the rule you want, rather than assuming the two formulas handle incomplete inputs identically.

Blank Cells, Zeros, and Missing Values

A blank cell and a cell containing zero are not the same thing. When A2 contains 18 and B2 is truly empty, =MIN(A2,B2) returns 18 because MIN ignores the empty cell reference. If B2 contains 0, the formula returns 0 because zero is a valid numeric value and is smaller than 18.

This distinction matters in worksheets where blank means not entered yet. If zero is a possible real measurement, price, or score, excluding it would produce the wrong answer. If zero is being used as a placeholder for missing data, decide whether the formula should treat that placeholder as a real value or leave the result blank until both values are supplied.

When both referenced cells are empty, MIN returns 0. That can be confusing if the intended result is an empty output. A common approach is to check that both cells contain values before performing the comparison. With the two inputs in A2 and B2, this formula returns a blank string until both cells are nonblank, then returns the lower value: =IF(OR(A2="",B2=""),"",MIN(A2,B2)). It assumes an empty cell or a formula returning an empty string should count as missing. If zero is a placeholder too, this test does not exclude it; the rule would need to be changed deliberately.

Consider whether a blank should mean missing, zero, or not applicable before adding conditions. A formula that silently treats missing data as zero can make a minimum look valid when it is not. For important summaries, a visible note such as “enter both values” may be clearer than showing a blank.

Numbers Stored as Text and Other Data Types

MIN is designed for numbers. If A2 and B2 are references and one contains text such as a word or a number stored as text, MIN generally ignores that text reference rather than comparing the characters. As a result, if A2 contains the numeric value 18 and B2 contains the text value “12” stored as text, MIN may return 18 instead of treating the text as numeric 12. This is a frequent reason a result looks unexpectedly high.

Check whether a value is stored as text if it appears left-aligned unexpectedly, has a warning indicator, or does not behave like other numbers. Converting the input cells to actual numbers is usually the best fix. Depending on the data, you can re-enter the values, use Excel’s conversion prompt, or use a dedicated conversion step. Do not rely on cell formatting alone: applying a number format does not necessarily convert text into a numeric value.

MIN can also compare dates and times because Excel stores them as numbers. A date is represented by a serial number, and a time is represented as a fraction of a day. With dates in A2 and B2, =MIN(A2,B2) returns the earlier date; format the result cell as a date if it appears as a number. With times in those cells, it returns the earlier time, provided both entries are valid Excel time values.

Useful Examples Beyond Two Inputs

Once the basic formula is clear, the same function can compare a whole group. With four numeric values in B2:E2, =MIN(B2:E2) returns the lowest value in that range. This can be useful for finding the lowest weekly reading, the smallest bid among several cells, or the least time recorded across a row. MIN accepts individual cell references as well as ranges.

To compare two values on another worksheet, use a sheet-qualified reference. If the values are in A2 and B2 on a worksheet named Quotes, then =MIN(Quotes!A2,Quotes!B2) returns the lower one. If a sheet name contains spaces, surround the sheet name with single quotation marks in the reference, as in =MIN('March Quotes'!A2,'March Quotes'!B2). The values still need to be numeric for a meaningful numeric comparison.

For percentages, MIN returns the smaller underlying percentage. If A2 is 8% and B2 is 5%, the result is 5%, assuming the cells contain numeric percentage values. If the result displays as 0.05, apply percentage formatting to the result cell; the calculation itself is still correct. For prices or measurements, use a suitable display format so readers can interpret the answer, but remember that formatting does not alter the comparison.

Common Problems and Checks

If the formula returns zero unexpectedly, check whether one of the cells contains a genuine zero, whether both references are blank, and whether an input is stored as text. If it returns the larger value, verify that the formula points to the intended cells and that the smaller-looking entry is a true number rather than text.

If Excel displays the formula instead of a result, the cell may be formatted as Text, or Show Formulas may be enabled. Change the cell format to General, re-enter the formula, and check the worksheet’s formula-display setting. A missing equals sign also makes an entry ordinary text rather than a formula.

An error in either referenced cell can cause the MIN formula to return an error as well. Check the source cells first instead of hiding the error automatically; it may reveal an invalid calculation upstream. Also check that the result cell is not included in its own inputs, which could create a circular reference.

  • Confirm that the formula references the two intended cells.
  • Check for blanks, zeros, text-formatted numbers, or errors in the inputs.
  • Format the result as a date, time, percentage, or currency when appropriate.
  • Use a range such as B2:E2 when comparing several values rather than writing a separate comparison for each pair.

Frequently Asked Questions

What is the Excel formula for the smaller of two numbers?
With the values in A2 and B2, use =MIN(A2,B2). It returns the smaller numeric value, or the shared value if the two numbers are equal.

Does MIN work if one cell is blank?
Yes. MIN ignores a blank cell referenced alongside a number, so it returns the number. If both referenced cells are blank, it returns 0. Add a separate condition if you want the result to remain blank until values are entered.

How do I return the lower value from more than two cells?
With the values in B2 through E2, use =MIN(B2:E2). The range can include more than four cells; adjust its endpoints to match the values you want to compare.

Does MIN return the cell that contains the lower value?
No. MIN returns the value, not the address of its source cell. If you need to identify the corresponding row or label, you need an additional lookup or comparison based on how your data is organized.

Why does MIN ignore a number I can see in a cell?
The apparent number may be stored as text. Convert it to a real numeric value, then recalculate. Number formatting alone may change how a cell looks without changing its underlying text value.

Can MIN find the earlier of two dates?
Yes, if both cells contain valid Excel dates. With the dates in A2 and B2, =MIN(A2,B2) returns the earlier date. Format the formula cell as a date if Excel displays the result as a serial number.

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.