In this Excel Tutorial I will show you how to use Min Function using Excel 2010.
For purpose of this tutorial I use packing slip template .
Min Function allow us to find the lowest value in the range.
Below is my invoice and I will try to find the lowest price. To do that I will type in the formula bar equal Min.
Next i open parenthesis and select the range. To finish this step I close parenthesis and click enter.
The results of lowest price are Daffodils- they cost 50.
In my next step I will go to Formulas tab to click Insert Function.
In the drop down box I select statistical function.
Now, I will scroll down to find the Min function. Next just click OK.
Next I will select the range.
In my case range is the column Price, so I select this and click OK.
I will show one more location where you can find Min Function - it is More Function.
I click More Function next I choose statistical one more time and scroll down to find Min Function.
The results will be the same like in previous example.
I hope this Excel Tutorial was helpful.
Katie and Emil