How to pick the lower or higher value of two cells in Excel?
Supposing, there are two list of numbers and you want to quickly pick up the lower or higher one between them, what can you do? This article provides some simple formulas to help you quickly get it done.
Pick the lower or higher value of two cells with formulas
Pick the lower or higher value of two cells with formulas
Please do as follows to pick the lower or higher value between two cells in Excel.
Pick the lower value between two cells
Syntax
=MIN(number1, [number2], …)
Arguments
- Number1: It can be a number, the reference to a number, or a range that contains numeric values.
- Number2 (Optional): It can be a number, the reference to a number, or a range that contains numeric values.
1. Select a blank cell, copy the below formula into it and then press the Enter key.
=MIN(A2,B2)
2. Then drag the Fill Handle down to get all lower values.
Notes:
- In the formula, A2 and B2 are the cells you will pick the lower value from;
- This formula can also help: =IF(A2<B2,A2,B2).
Pick the higher value between two cells
Syntax
=MAX(number1, [number2], …)
Arguments
- Number1: It can be a number, the reference to a number, or a range that contains numeric values.
- Number2 (Optional): It can be a number, the reference to a number, or a range that contains numeric values.
1. Select a black cell, copy one of the below formulas into it and press the Enter key. And then drag the Fill Handle down to get all higher values.
=MAX(A2,B2)
=IF(A2>B2,A2,B2)
Related articles
Find the max or min value based on criteria in Excel
Supposing you have the data range, column A contains the product names, and column B has the order quantities, now, you want to find the max order value of the product KTE. In Excel, how could we extract the max or min value based on one or more criteria? The methods in this tutorial can do you a favor.
Find max or min value in a group in Excel
Generally, finding the max or min value in a range may be easy for most of Excel users, but how about finding the max or min value in each group? Here this tutorial is talking about the tricks to find the max or min value in a group in Excel.
Calculate average without max and min values in Excel
As we all known, the normal Average function will get the average value of all the selected cells in Excel. But here, you want to calculate the average excluding the highest and lowest values from the selected numbers, how could you solve this problem? Please try the methods in this tutorial.
Related articles
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!