"Excel 2007 MAX Function - An Example Demonstration"

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 2007 MAX Function

• Enter the following data into the Excel spreadsheet.

• Click on cell C8 or any other cells where the results will be displayed.
• 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.
• 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.

Related Topics:

How to Write a Formula in Microsoft Excel 2007?
Knowing the Different Types of Excel 2007 Functions
Using Excel 2007 IF Function to Perform the Calculation That Can Ease Your Daily Related Tasks
How to Use the Cell Function in Microsoft Excel 2007?
Guide to Use the NOW Function Correctly in Excel 2007
Demonstration of Using the Date and Time Functions with Excel 2007
Using the Excel 2007 Count Function - Example Demonstration
Use the Microsoft Excel 2007 Product Function to Perform the Calculation
Guide to Use the Excel 2007 Radian Function Correctly

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the Excel 2007 Max function info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb