Related article: Excel 2007 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:
Note: For help with this example, see the image to the right.
- Enter the following data into cells C1 to C6: 114,165,178,143,130,167.
- Click on cell C7 - the location where the results will be displayed.
- Type = max( in cell C7.
- Drag select cells C1 to C6 with the mouse pointer.
- Type the closing bracket " ) " after the cell range in cell C7.
- Press the ENTER key on the keyboard.
- The answer 178 appears in cell C7.
- The complete function = MAX ( C1 : C6 ) appears in the formula bar.
Related Articles


