- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel Statistical - MIN Function
Description
The MIN function returns the smallest number in a set of values.
Syntax
MIN (number1, [number2] ...)
Arguments
| Argument | Description | Required/ Optional |
|---|---|---|
| Number1 | 1 to 255 numbers for which you want to find the minimum value | Required |
| number2,... | Optional |
Notes
Arguments can either be numbers or names, arrays, or references that contain numbers.
Logical values and text representations of numbers that you type directly into the list of arguments are counted.
If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.
If the arguments contain no numbers, MIN returns 0.
If any values that are supplied directly to the Function are non-numeric, MIN returns #VALUE! Error.
If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016.
Example
