Find the largest or smallest value
The MAX function finds the largest number in a range, and the MIN function finds the smallest number in a range.
The picture illustrates the use of MAX.
Start by clicking in cell F7. Then:
On the Home tab, in the Editing group, click the arrow on the Sum button, and then click Max in the list.
Press ENTER to display the result in cell F7. The largest value in the series is 131.95.