Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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.


Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

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!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.