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.
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
|
