Min Function

---

The next function we will discuss is 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.

---

Lets 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

---

Min Function

486195