MAX returns the highest value in a range, and MIN returns the lowest. For instance, =MAX(A1:A10) and =MIN(A1:A10) find the maximum and minimum values in the range A1 through A10, respectively.