Excel MIN Function with Examples

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:

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.