1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

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 / 2013 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.