The MIN function in Excel are used to find the lowest values in a list of values. This is especially useful when you have a data set of a few thousand values and don’t have the time to go through each value separately in order to determine which one is the lowest.
To use the MIN function, we use the following syntax:
…where both number1 and number2 are either numbers or references to cells containing numbers.
How to use it
We can find the minimum value between two numbers like this:
To find the minimum of a list of numbers is just as easy:
We can also find the minimum value between the values in two cells:
This will produce an answer of 5.
When you want to find the minimum value of a list of cells, insert a cell range, like this:
This will return 1.
You can combine all the above into one function, using both cell references and real numbers:
This, of course, will produce an answer of 0.
Easiest way to use it
To have Excel automatically find the minimum value of a list of cells, select the cell underneath the list. Then click on the AutoSum dropdown list on the Formulas bar, and select Min.
Excel is smart enough to select the correct range of cells, and returns an answer of 0.