• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

# Excel MIN Function

## Excel MIN Function Tutorial

Excel MIN Function Tutorial

### 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

Ted French