Function Problems

How to Use an Excel Formula to Return the Smaller of Two Values

Camila MilosovichCamila Milosovich Nov 10, 2026 871 views

Question details

The user wants to compare two specific columns in a spreadsheet and automatically return the lower value into a new cell.

Excel Formula to Return the Smaller of Two Values
Product
Excel
Device & OS
not provided
Scenario
Comparing numerical data between two columns (e.g., Column A and Column D) to extract the minimum value for accurate reporting or data analysis.
Observed behavior
Populating a destination cell with the value from Column D when it is lower than Column A, or the value from Column A when it is lower.
Before you start

Ensure that the data in both columns are formatted as numbers. If the cells are formatted as text, the formulas may return an error or produce inaccurate comparisons.

Solution 1Recommended

Use the MIN Function to Find the Smaller Value

The MIN function is the most straightforward and efficient method to return the lowest number from a given set of cells.

The MIN formula automatically evaluates the provided arguments and outputs the smallest numeric value. It efficiently ignores empty cells and text strings, making it highly reliable for numerical comparison.

1
Select the destination cell

Click on the empty cell where you want the smaller value to be displayed (for example, cell E2).

2
Enter the MIN formula

Type =MIN(A2, D2) into the cell or the formula bar at the top of the worksheet.

3
Apply the formula

Press the Enter key. The cell will now calculate and display the smaller of the two values.

4
Copy the formula down

Click and hold the small square (fill handle) at the bottom-right corner of the destination cell, then drag it down to apply the formula to the remaining rows in your dataset.

Use the MIN Function to Find the Smaller Value
Quick and Clean: Using MIN is generally preferred over logical operators because it is shorter, easier to read, and less prone to syntax errors.
Fast and Free Spreadsheet Tool

Easily Calculate Minimum Values with WPS Spreadsheet

WPS Spreadsheet is a powerful, free tool for data analysis, offering comprehensive support for essential functions like MIN, MAX, and IF. It handles large datasets smoothly and features an intuitive interface that makes formula entry a breeze.

  1. 1. Download and Install: Download WPS Office from the official website and complete the quick installation process.
  2. 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing Microsoft Excel workbook.
  3. 3. Select a Cell: Click an empty cell adjacent to the two columns you wish to compare.
  4. 4. Input the Formula: Type =MIN(A2, D2) and press Enter to instantly calculate and return the smaller value.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) file formats.Built-in support for hundreds of standard formulas, including MIN and IF.Lightweight software that runs flawlessly on Windows, Mac, and Linux.Smart auto-suggest feature helps you write complex formulas accurately without memorizing syntax.
microsoft office alternative - wps office

Frequently Asked Questions

Can I compare more than two columns using the MIN function?

Yes. You can add multiple cells or entire ranges separated by commas. For example, =MIN(A2, B2, C2, D2) or =MIN(A2:D2) will evaluate all referenced cells and return the single smallest value among them.

What happens if one of the cells being compared is blank?

The MIN function automatically ignores completely blank cells. If you compare a number with a blank cell using MIN, it simply returns the number. However, if you use the IF function, Excel treats the blank cell as a zero, which might incorrectly return 0 as the smaller value.

How do I return the larger value between two columns instead?

To find the larger value, replace the MIN function with the MAX function (e.g., =MAX(A2, D2)). If you are using the IF function, change the logical operator to greater than (e.g., =IF(D2>A2, D2, A2)).

Does the MIN formula work with dates and times?

Yes, spreadsheet programs store dates and times as sequential serial numbers. The MIN function can accurately compare two dates and will return the earlier date, as it correlates to the smaller serial number.