Max and Min Functions
The MAX and MIN functions automatically find the maximum and minimum of a range of values.
MAX Function
Now that Sean knows the average performance value, he wants to know which student has scored the highest. To calculate the maximum value, he will use the MAX function in Excel.
To compute the maximum,
1. In cell B20, enter the text Highest Marks.
2. In cell C20, enter the formula, =MAX(C3:C18)
3. Press Enter.
4. The maximum % value of marks scored by a student appears in the cell.
MIN Function
Obviously, Sean next wants to know the student who has scored the least marks, so he can pay more attention to this student in the next semester. For this, he will use the MIN function of Excel.
To compute the minimum,
1. In cell B21, enter the text, Lowest Marks.
2. In cell C21, enter the formula, =MIN(C3:C18)
3. Press Enter.
4. The figure for the lowest % value of marks scored by a student appears in the cell.
