How to Use an Excel Formula to Return the Smaller of Two Values
Question details
The user wants to compare two specific columns in a spreadsheet and automatically return the lower value into a new cell.

- 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.
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.
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.
Click on the empty cell where you want the smaller value to be displayed (for example, cell E2).
Type =MIN(A2, D2) into the cell or the formula bar at the top of the worksheet.
Press the Enter key. The cell will now calculate and display the smaller of the two values.
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.

Compare Values Using the IF Function
The IF function provides a logical test to compare two cells. This is a great alternative if you plan to add more complex conditions later.
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. Download and Install: Download WPS Office from the official website and complete the quick installation process.
- 2. Open Your Workbook: Launch WPS Spreadsheet and open your existing Microsoft Excel workbook.
- 3. Select a Cell: Click an empty cell adjacent to the two columns you wish to compare.
- 4. Input the Formula: Type =MIN(A2, D2) and press Enter to instantly calculate and return the smaller value.

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.




