Exceljet

Quick, clean, and to the point

Maximum value

Excel formula: Maximum value
Generic formula 
=MAX(range)
Explanation 

To get the maximum value from a set of numbers, use the MAX function.

In the example shown, the formula in cell I6 is:

=MAX(C6:G6)

The MAX function is fully automatic. It accepts one or more arguments, which can be numbers or cell references that point to numbers, then returns the maximum value.

Author 
Dave Bruns
Related formulas 
Excel formula: Maximum value if
Maximum value if
To get a maximum value based on criteria, you can use the MAX function together with the IF function in an array formula. In the example shown, the formula in cell G6 is: { = MAX ( IF ( names = F6 , times )) } Where names is the named range B6:B17,...
Excel formula: Minimum value
Minimum value
To get the minimum value from a set of numbers, use the MIN function. In the example shown, the formula in cell I6 is: = MIN ( C6:G6 ) The MIN function is fully automatic. It accepts one or more arguments, which can be numbers or cell references...
Excel formula: Minimum value if
Minimum value if
To get a minimum value based on criteria, you can use the MIN function together with the IF function. In the example shown, the formula in G6 is: { = MIN ( IF ( names = F6 , times )) } Where "names" is the named range B6:B17, and times is the named...
Excel formula: Minimum if multiple criteria
Minimum if multiple criteria
To get the minimum value in a data set using multiple criteria (i.e. to get MIN IF), you can use and array formula based on the MIN and IF functions. In the example shown the formula in I6 is: { = MIN ( IF ( color = G6 , IF ( item = H6 , price...
Excel formula: Maximum if multiple criteria
Maximum if multiple criteria
To get the maximum value in a data set based on more than one criteria (i.e. to get MAX IF), you can use an array formula based on the MAX and IF functions. In the example shown, the formula in I6 is: { = MAX ( IF ( color = G6 , IF ( item = H6 ,...
Excel formula: Get next scheduled event
Get next scheduled event
To get the next scheduled event from a list of events with dates, you can use an array formula based on the MIN and TODAY functions to find the next date, and INDEX and MATCH to display the event on that date. In the example shown, the formula in G6...
Related functions 
Excel MAX function
Excel MAX Function

The Excel MAX function returns the largest numeric value in a range of values. The MAX function ignores empty cells, the logical values TRUE and FALSE, and text values.

Excel MAXIFS function
Excel MAXIFS Function

The Excel MAXIFS function returns the largest numeric value that meets one or more criteria in a range of values. MAXIFS can be used with criteria based on dates, numbers, text, and other conditions. MAXIFS supports logical operators (>,...

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formula Examples, thoughtfully explained.