Excel MAX Function

The MAX function makes it easy 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 ... argument30: Arguments 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. 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. When you click on cell C7 the complete function = MAX (C1 : C6) appears in the formula bar above the worksheet.

• excel max function
• excel statistical functions
• excel largest numbers