The MIN and MAX functions help you find the largest and smallest numeric values in a range of cells.
Insert a MAX Function
- Click in the cell where you want to add the MAX function.
- Click Insert on the menu bar.Select Function.
- Select Function.
Since the MAX function is one of the most commonly-used functions, it's listed outside of the function categories.
- Select MAX.
The MAX function is inserted into the formula, and now we need to select the range of cells we want to analyze.
- Select the range of cells you want to analyze.
- 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.
- Click in the cell where you want to add the MIN function.
- Click Insert on the menu bar.
- Select Function.
- Select MIN.
- Select the range of cells you want to analyze.
- Press Enter.
The minimum value from the selected range is displayed.
