Max and Min functions - Functions for maximum and minimum values in Excel The Max and Min functions are two frequently used functions in Excel, to return the largest, smallest value of an argument or range of data containing numbers.