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.

Excel Cheat Sheet

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.