Excel 2007 MIN Function

The MIN function, one of Excel's statistical functions, is used to find the smallest value in a list of arguments.

Related article: Excel 2003 MIN Function

The syntax for the MIN function is:

=MIN ( 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 MIN 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 MIN 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 114 should appear in cell C7 as it is the largest number in the selected range.
   
   
9. The complete function = MIN (C1 : C6) appears in the formula bar above the worksheet.

• Excel 2007 MAX Function
• Excel 2007 SUMIF