MIN Function

Example

Explanation

MIN function is the opposite of MAX function, and it’s used when we want to find the minimum value within a range of cells.

Syntax

The syntax of the MIN function is as follows:

=MIN(value1,value2,value3…)

We can insert into the MIN function a range of cells, for example:

=min(A1:A4)

The function above will look within the cells in range A1 to A4, and return the smallest value.

Practice MIN function

Now, let’s try to find minimum value using MIN function:

Minimum Excercise 1

Minimum Excercise 2