## 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.

### Best Office Productivity Tools

 🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions… Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ... Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup .... Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List .... Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ... Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ... Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

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!