How is the MIN function used to determine the highest number in a range?

The MIN function is the function that you would use to find the lowest value in a set. You could also use the SMALL function, but that is more when you are looking for a value other than the lowest, such as the second lowest or third lowest. That is specified by a number at the end. Both of the following will find the lowest value in the range of A2 to A16:

=MIN(A2:A16)

=SMALL(A2:A16,1)