How to Use MIN and MAX Functions in Microsoft Excel
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.
Excel adds the MAX formula and displays the biggest number from the specified range.
Excel adds the MIN formula and displays the smallest number from the specified range.