MS Excel: MIN Function (WS)
In Microsoft Excel, the MIN function returns the smallest value from the numbers provided.
Syntax
The syntax for the MIN function is:
MIN( number1, number2, ... number_n )
number1, number2, ... number_n are numeric values - they can be numbers, named ranges, arrays, or references to numbers. There can be up to 30 values entered.
Applies To
- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000
Type of Function
- Worksheet function (WS)
Worksheet Function Example
Let's take a look at an example to see how you would use the MIN function in a worksheet:
Based on the Excel spreadsheet above, the MIN function would return the following:
| =MIN(A2, A3) | would return 7.2 |
| =MIN(A3, A5, -3) | would return -3 |
| =MIN(A2:A6) | would return 5.4 |
| =MIN(A2:A6, 3.6) | would return 3.6 |