Excel 2007 MAX Function

Find the Largest Number in Excel

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.

Related article: Excel 2003 MAX Function

The syntax for the MAX function is:

=MAX( argument1, argument2, ... argument30 )

Argument1, argument 2, ... argument 30 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.

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. Click on the Formulas tab.
   
   
4. Choose More Functions > Statistical from the ribbon to open the function drop down list.
   
   
5. Click on MAX in the list to bring up the function's dialog box.
   
   
6. Drag select cells C1 to C6 on the spreadsheet to enter the range into the dialog box.
   
   
7. Click OK.
   
   
8. The answer 178 should appear in cell C7 as it is the largest number in the selected range.
   
   
9. The complete function = MAX (C1 : C6) appears in the formula bar above the worksheet.

• Excel 2007 AutoMAX
• Excel 2007 MIN Function
• Excel 2007 AVERAGE Function