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.

   
5. Select the range of cells you want to analyze.
   
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.
   
5. Select the range of cells you want to analyze.
   
6. Press Enter.

The minimum value from the selected range is displayed.