
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
- Click in the cell where you want to add the formula.
- Click the Sum button list arrow.
- Select Max.
- If necessary, select the desired cell range.
- Click Enter or press the Enter key.
Excel adds the MAX formula and displays the biggest number from the specified range.
Create a MIN Formula
- Click in the cell where you want to add the formula.
- Click the AutoSum button list arrow.
- Select Min.
- If necessary, select the desired cell range.
- Click Enter or press the Enter key.
Excel adds the MIN formula and displays the smallest number from the specified range.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.
- COUNT Function in Excel
- Excel Formulas
- Excel SUM Formula