Log In

Excel MAX Function & MIN Function

How to Use MIN and MAX Functions in Microsoft Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Prices
Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

Excel MAX Function & MIN Function

The Excel MAX function can tell you what the largest numeric value is in a range of cells. The opposite of MAX is the MIN function, which returns the smallest numeric value in a range of cells.

Create a MAX Formula

  1. Click in the cell where you want to add the formula.
  2. Click the Sum button list arrow.
  3. Select Max.
    Create a MAX Formula
  4. If necessary, select the desired cell range.
  5. Click Enter or press the Enter key.
    Create a MAX Formula

Excel adds the MAX formula and displays the biggest number from the specified range.

Create a MIN Formula

  1. Click in the cell where you want to add the formula.
  2. Click the AutoSum button list arrow.
  3. Select Min.
    Create a MIN Formula
  4. If necessary, select the desired cell range.
  5. Click Enter or press the Enter key.
    Create a MIN Formula

Excel adds the MIN formula and displays the smallest number from the specified range.

You Get:
  • LinkedIn-ready certificate
  • Skill assessments
  • Bite-sized, interactive lessons
  • Saved progress

Links to Other Courses