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.
The syntax of the MIN function is as follows:
We can insert into the MIN function a range of cells, for example:
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: