1. Computing

Excel 2003 MIN Function

Find the Smallest Number in Excel


Find the Smallest Number in Excel

Find the Smallest Number in Excel

© Ted French

Note: These instructions will work for all versions of Excel.

Related tutorial: Excel 2007/ 2010 MIN Function

The MIN function, one of Excel’s statistical functions, is used to find the smallest or minimum value in a given list of numbers or arguments.

The syntax for the MIN function is:

=MIN ( argument1, argument2, ... argument30 )

Argument1, argument2, ... argument30 can be numbers, named ranges, arrays, or cell references. Up to 30 arguments can be entered.

Example: Using Excel's MIN Function

For help with this example, see the image above.

  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. Type “=min(” in cell C7.

  4. Drag select cells C1 to C6 with the mouse pointer.

  5. Type the closing bracket " ) " after the cell range in cell C7.

  6. Press the ENTER key on the keyboard.

  7. The answer 114 appears in cell C7.

  8. The complete function =MIN(C1:C6) appears in the formula bar.

©2014 About.com. All rights reserved.