MIN Function:
The MIN function returns the smallest numeric value in the data provided. The MIN function can be used to return the smallest value from any type of numeric data. For example, MIN can return the fastest time in a race, the earliest date, the smallest percentage, the lowest temperature, or the bottom sales number.
In a cell, type =MAX( Select a range of numbers using the mouse. Type the closing parenthesis. Press the Enter key to complete your formula.
----------------------------------
MAX Function:
MAX will return the largest value in a given list of arguments. From a given set of numeric values, it will return the highest value.
In a cell, type =MAX( Select a range of numbers using the mouse. Type the closing parenthesis. Press the Enter key to complete your formula.