## 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**

: The first argument*value1*: [Optional]. The second argument*value2*

### Remarks

- You can specify up to 255 arguments.
- Arguments (
,*value1*,...) can either be numbers, arrays, or references containing numeric values.*value2* - 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.