Excel MAX Function

Note: These instructions will work for all versions of Excel from Excel 95 to Excel 2010.

Related tutorial: Excel 2007 / 2010 MAX Function

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, argument2, ... argument30 can be numbers, named ranges, arrays, or cell references. Up to 30 arguments can be entered.

Example Using Excel's MAX Function:

1. Enter the following data into cells C1 to C6: 114,165,178,143,130,167.
   
   
2. Click on cell C7 - the location where the results will be displayed.
   
   
3. Type = max( in cell C7.
   
   
4. Drag select cells C1 to C6 with the mouse pointer.
   
   
5. Type the closing bracket " ) " after the cell range in cell C7.
   
   
6. Press the ENTER key on the keyboard.
   
   
7. The answer 178 appears in cell C7.
   
   
8. The complete function = MAX ( C1 : C6 ) appears in the formula bar.

• Excel MIN Function
• Excel Functions
• Excel COUNT Function

• excel max function
• excel statistical functions
• maximum numbers