MIN and MAX

How to Use the MIN and MAX Functions in Google Sheets

MIN and MAX

The MIN and MAX functions help you find the largest and smallest numeric values in a range of cells.

Insert a MAX Function

  1. Click in the cell where you want to add the MAX function.
  2. Click Insert on the menu bar.Select Function.
  3. Select Function.

    Since the MAX function is one of the most commonly-used functions, it's listed outside of the function categories.

  4. Select MAX.

    The MAX function is inserted into the formula, and now we need to select the range of cells we want to analyze.

    How to Insert a MAX function in Google Sheets.
  5. Select the range of cells you want to analyze.
    How to Insert a MAX function in Google Sheets.
  6. Press Enter.

The selected cell now displays the biggest number from the specified range.

Insert a MIN Function

The MIN function works the same way but shows the smallest numerical value in a range.

  1. Click in the cell where you want to add the MIN function.
  2. Click Insert on the menu bar.
  3. Select Function.
  4. Select MIN.
    How to Insert a MIN function in Google Sheets.
  5. Select the range of cells you want to analyze.
    How to Insert a MIN function in Google Sheets.
  6. Press Enter.

The minimum value from the selected range is displayed.

FREE Quick Reference

Click to Download