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