MS Excel: MIN Function (WS)
In Microsoft Excel, the MIN function returns the smallest value from the numbers provided.
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.
- 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|