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

- Enter the following data into cell D3: 78
- Enter the following data into cells E1 to E3: 114, 165, =D3
**Note:**since E3 contains a cell reference to D3, the number in D3 (**78**) shows in E3- Enter the following data into cells E5 to E6: 130, text
- Cell E4 is intentionally left blank
- Click on cell E7 - the location where the results will be displayed
- Click on the
*Formulas*tab - Choose
**More Functions > Statistical**from the ribbon to open the function drop down list - Click on
*MIN*in the list to bring up the function's dialog box - Drag select cells E1 to E6 on the worksheet to enter the range into the dialog box.
- Click OK
- The answer
**78**should appear in cell E7 as it is the smallest number in the selected range - The function ignores the blank cell E4 and the text data in cell E6
- When you click on cell E7 the complete function
**= MIN (E1 : E6)**appears in the formula bar above the worksheet