MIN and MAX The MIN and MAX functions are easy to use and pretty straightforward. They take a series of numbers and find the smallest or largest value in the set.