Ms Excel Max Function

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.

 

---

Let's 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