How to Use the MIN Function in Excel
In this tutorial, you'll learn how to use the Excel MIN function.
MIN is a function to get the smallest value in a set of values.
MIN Syntax
The syntax of the MIN() function is as follows:
=MIN(value1, [value2], ...)
Arguments
- value1: The first argument
- value2: [Optional]. The second argument
Remarks
- You can specify up to 255 arguments.
- Arguments (value1, value2,...) can either be numbers, arrays, or references containing numeric values.
- If the arguments contain no numbers, MIN() returns 0.
- Text, empty cells, or logical values in the array or reference are ignored.
MIN Function Examples
Example 1
The following example gets the smallest value in a group of 3 numbers:
=MIN(100,30,240)
The above formula returns 30, which is the smallest value amount 100, 30, and 240.
Let's see more examples below.
Demo data:
A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Date | Item Code | Item Name | Qty | Unit Price | Amount |
2 | 11/4/2019 | Item1001 | Dell Desktop Green 1 | 3 | 1200 | 3600 |
3 | 11/4/2019 | Item1002 | Dell Desktop Black 2 | 1 | 1240 | 1240 |
4 | 11/5/2019 | Item1003 | Dell Desktop Blue 3 | 3 | 1130 | 3390 |
5 | 11/5/2019 | Item1003 | Dell Desktop Blue 3 | 4 | 1130 | 4520 |
6 | 11/5/2019 | Item1002 | Dell Desktop Black 2 | 5 | 1240 | 6200 |
7 | 11/6/2019 | Item1001 | Dell Desktop Green 1 | 1 | 1120 | 1120 |
8 | 11/7/2019 | Item1001 | Dell Desktop Green 1 | 2 | 1150 | 2300 |
9 | 11/9/2019 | Item1003 | Dell Desktop Blue 3 | 4 | 1100 | 4400 |
10 | 11/9/2019 | Item1002 | Dell Desktop Black 2 | 6 | 1200 | 7200 |
11 | 11/10/2019 | Item1003 | Dell Desktop Blue 3 | 3 | 1000 | 3000 |
Example 2
You can get the smallest value in a range of cells, as the following example shows:
=MIN(F2:F11)
MIN returns 1120, which is the smallest value in the range F2: F11.
Example 3
Here is another example of the MIN() function:
=MIN(1030,F2:F4,F6:F8,F10:F11,1000)
MIN returns 1000, which is the smallest value in the group.
Example 4
If a cell or a range of cells doesn't contain numbers, MIN() returns 0.
Here is an example:
=MIN(C2:C11)
In this tutorial, you've learned how to use the Excel MIN function.
You use the MIN function to get the smallest value in a group of values.