MAX Function in Excel

Question

What is the MAX function in Excel?

Answer

The MAX function, one of Excel's statistical functions, is used to find the largest or maximum number in a given list of values or arguments.  The syntax for the MAX function is: =MAX( argument1, argument2, ... argument30 )  
 
Argument1 ... argument 30: The arguments can be numbers, named ranges, arrays, or cell references. Up to 30 arguments can be entered.  

For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3

If you need further assistance, please click the CTL Support Request button on this page

CTL Support Request Print Article

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.