MS Excel Min Function

Min (which stands for minimum). This will return the smallest (Min) value in the selected range of cells. 

• Blank entries are not included in the calculations of the Min Function. 

• Text entries are not included in the calculations of the Min Function.

 

---

Let's use the table here for the discussion that follows. We will look at several different specific examples that show how the min functions can be used!

A 1 10 2 20 3 30 4 test 5

---

Example of min	Cells to look at	Ans. min
=min (A1:A4)	A1, A2, A3, A4	10
=min (A2:A3, 100)	A2, A3 and 100	20
=min (A1, A3)	A1, A3	10
=min (A1, A5)	A1, A5 (displays the smallest number)	10