Min function will be used to search for the smallest value in a data range, maybe a whole worksheet or only a certain range of data. How to use the Min function in Excel is guided in the following article.

**Syntax**: =MIN(number1, [number2], …)

The MIN function syntax has the following arguments:

- number1 – the first number from a set of values from which you want to get the minimum value.
- [number2], .. – (optional) second number from a set of values from which you want to get the minimum value. Up to 255 arguments can be used in the MIN function.

**MIN in Excel Example**:

**1.1 For example, to get the smallest value in the range C17:C24, use this simple formula:**

**Syntax**: =MIN(C17:C24)

**Result**:

**1.2 For example, to get the smallest value in the range D18,D20,D22,D24, use this simple formula:**

**Syntax**: =MIN(D18,D20,D22,D24)

**Result**:

**1.3 For example, to get the smallest value in the range C17:E24, use this simple formula:**

**Syntax**: =MIN(C17:E24)

**Result**: