Topic 23: Using the Excel MAX Function to find...

[seema]

The Excel 2007 MAX function, one of Excel's statistical functions, is used to find the largest value in a given list of arguments. 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.


To use the Excel MAX function

Enter the following data into the Excel spreadsheet. Click on cell C8 or any other cells where the results will be displayed.

Similar Threads:

• Topic 20: Using the Excel NOW Function
• Topic 22: Use Excel MAX() Function to Find the Largest Number in an List
• Topic 21: Find the minium Value using Excel MIN() Function
• Topic 20: Excel AND() Function
• Topic 16: Using the Excel CHOOSE() Function

[seema]

From the Formulas tab, in the Function Library group, click the More Functions icon and point to Statistical to open the function drop down list. Click on MAX in the list to bring up the function's dialog box.

[seema]

From the Max Function Arguments dialog box displayed, type C1:C6 or you can drag the mouse from cell C1 to C6. Click OK. The result will display on the cell C8. If you choose the different ranges, the following result will display.=Max(C1, C2) would return 632. =Max(C3, C5, 896) would return 896. =Max(C2:C6) would return 808.