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

Excel MIN Function

Excel MIN Function Tutorial


Excel MIN Function Tutorial

Excel MIN Function Tutorial

© Ted French

Excel MIN Function Overview

The MIN function is used to find the smallest or minimum value in a range of data.

If the range selected for the function contains blank cells or cells containing text data, these cells are ignored by the function.

Excel MIN Function Syntax and Arguments

The syntax for the MIN function is:

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

The arguments for the MIN function are:

Argument1 ... argument 255: Arguments can be numbers, named ranges, arrays, or cell references. Up to 255 arguments can be entered.

Example Using Excel's MIN Function:

The following example will find the smallest number in a range of data.

To show how the function deals with different types of data, the range includes a blank cell, a cell reference to data in a different column, and text data.

For help with this example see the image above.

  1. Enter the following data into cell D3: 78

  2. Enter the following data into cells E1 to E3: 114, 165, =D3

  3. Note: since E3 contains a cell reference to D3, the number in D3 ( 78 ) shows in E3

  4. Enter the following data into cells E5 to E6: 130, text

  5. Cell E4 is intentionally left blank

  6. Click on cell E7 - the location where the results will be displayed

  7. Click on the Formulas tab

  8. Choose More Functions > Statistical from the ribbon to open the function drop down list

  9. Click on MIN in the list to bring up the function's dialog box

  10. Drag select cells E1 to E6 on the worksheet to enter the range into the dialog box.

  11. Click OK

  12. The answer 78 should appear in cell E7 as it is the smallest number in the selected range

  13. The function ignores the blank cell E4 and the text data in cell E6

  14. When you click on cell E7 the complete function = MIN (E1 : E6) appears in the formula bar above the worksheet

©2014 About.com. All rights reserved.