• The Facebook Platform

Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2010
    Lahore, Pakistan
    Rep Power

    Default MS Excel 2007 Lecture # 24

    "Excel 2007 MAX Function - An Example Demonstration"

    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.
      excel max function data - MS Excel 2007 Lecture # 24
    • 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.
      max function - MS Excel 2007 Lecture # 24
    • 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.
      excel max function arguments - MS Excel 2007 Lecture # 24
    • 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.

    Find Me On Social Networks

    Facebook | Twitter | Google+


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts