Excel MIN Function

This tutorial explains how to use the Excel MIN function.

Description

The Excel MIN function get the smallest value in a set of values.

Syntax
=MIN(value1, [value2], …)
Arguments

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

You can specify up to 255 arguments.

Arguments (value1, value2,…) can either be numbers, arrays, or references that contain numeric values.

If the arguments contain no numbers, MIN returns 0.

Text, empty cells or logical values in the array or reference are ignored.

Example

Here is our sample data.

A B C D E
1 Item Code Item Name Qty Unit Cost ($) Unit Price ($)
2 Item0001  Desktop PC 11 21 200.00 225.00
3 Item0002  Desktop PC 12 22 150.00 750.00
4 Item0003  Desktop PC 13 25 210.00 235.00
5 Item0004   Desktop PC 14 25 780.00 785.00
6 Item0005   Desktop PC 15 30 1040.00 1010.00
7 Item0006   Desktop PC 16 30 230.00 255.00
8 Item0007  Desktop PC 17 40 274.00 290.00

Example 1:

=MIN(1,3,2)

In Example 1, MIN returns 1, which is the smallest value.

Example 2:

=MIN(C2:C8)

In Example 2,  MIN returns 21, which is the smallest value in the range C2:C8.

Example 3:

Let’s see another example below.

=MIN(C2:C8, 10)

In Example 3,  as you can see, the smallest value in the range C2:C8 (the first argument) is 21 and the second argument is 10. MIN returns 10, which is the smallest value.

In this tutorial, you have learned how to use the Excel MIN function. We use the Excel MIN function to get the smallest value in a group of values.

Here is a full list of Microsoft Excel functions.