Max Function

---

The next function we will discuss is Max (which stand for Maximum). This will return the largest (max) value in the selected range of cells.

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

---

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

	A
1	10
2	20
3	30
4	test
5

---

Example of Max	Cells to look at	Ans. Max
=max (A1:A4)	A1, A2, A3, A4	30
=max (A1:A4, 100)	A1, A2, A3, A4 and 100	100
=max (A1, A3)	A1, A3	30
=max (A1, A5)	A1, A5	10

---

Max Function

535859